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])