Please do as per directed to generate a table with the help from another table. We will make use of a calculated table to achieve this. A calculated table is a calculated data object created by a DAX query or expression which is derived from a part or whole of the table. We can also use more than one table to make a calculated table but there must be at least one existing one.
First click on the “New Table” option which you can find under “Modelling” tab
![Create Table from table in Power BI](https://nitrocdn.com/hXyuVswrwlizpLWkYZeWRpAyePZJyHjB/assets/static/optimized/rev-c66563d/www.epcgroup.net/wp-content/uploads/2021/05/1a0c866596926efb0f2ee0acc23d0185.image001-1.png)
- A Power BI DAX formula bar will open where you can write and execute DAX expression
- Assume the previous table, named Sales had 3 columns: Order Id, Order_No, Order_Date
- We will put in the following DAX Expression:
![Power BI table functions](https://nitrocdn.com/hXyuVswrwlizpLWkYZeWRpAyePZJyHjB/assets/static/optimized/rev-c66563d/www.epcgroup.net/wp-content/uploads/2021/05/9ab8d55afea42d6369e0e8a05dd09f50.image002.png)
Item = SUMMARIZE (Sales, Sales[item_id], Sales[Item_No])
You can also make use of the SELECT COLUMN function to make a subset instead of grouping them
- SELECTCOLUMNS(Sales, “Id and No”, [item_id]&”, “&[item_no])
- Execute the above query and you will have another Table summarized columns designed by the name parameters.
Below, another sample of SelectColuns for reference.
![](https://SUMMALAI.COM/wp-content/uploads/2021/10/SelectColumns-1024x576.png)
Continue to the above sample, if you want to have the most recent record only. Then SUMMARIZE is the one that can do the job for you.
![](https://SUMMALAI.COM/wp-content/uploads/2021/10/SUMMARIZE-1024x576.jpg)
Now, you can see the records is reduced from 540K to only 30K rows.