New table (View) in Data Model

This article is about Views (tables dynamically generated from other tables) in Data Model in Power BI. 

It can be simply done by writing a DAX query, whose output can be a table.

We will be working with this table of sales data.

In first example lets filter it so as the result only contains rows with “Carrot” in Goods. Go to Modelling / New table and type:

• Carrot only = FILTER(‘original data’;’original data'[Goods]=”Carrot”)

You can also generate a list of unique values. 

• List of items = DISTINCT(‘original data'[Goods]) 

New table can also be done by removing columns from original table.

• Remove one column = ALLEXCEPT(‘original data’;’original data'[Goods category])