![\"Create](\"https:\/\/nitrocdn.com\/hXyuVswrwlizpLWkYZeWRpAyePZJyHjB\/assets\/static\/optimized\/rev-c66563d\/www.epcgroup.net\/wp-content\/uploads\/2021\/05\/1a0c866596926efb0f2ee0acc23d0185.image001-1.png\")
<\/figure>\n\n\n\n- A Power BI DAX formula bar will open where you can write and execute DAX expression<\/li>
- Assume the previous table, named Sales had 3 columns: Order Id, Order_No, Order_Date<\/li>
- We will put in the following DAX Expression:<\/li><\/ul>\n\n\n\n
![\"Power](\"https:\/\/nitrocdn.com\/hXyuVswrwlizpLWkYZeWRpAyePZJyHjB\/assets\/static\/optimized\/rev-c66563d\/www.epcgroup.net\/wp-content\/uploads\/2021\/05\/9ab8d55afea42d6369e0e8a05dd09f50.image002.png\")
<\/figure>\n\n\n\nItem = SUMMARIZE (Sales, Sales[item_id], Sales[Item_No])<\/p>\n\n\n\n
You can also make use of the SELECT COLUMN function to make a subset instead of grouping them<\/p>\n\n\n\n
- SELECTCOLUMNS(Sales, \u201cId and No\u201d, [item_id]&\u201d, \u201c&[item_no])<\/li>
- Execute the above query and you will have another Table summarized columns designed by the name parameters.<\/li><\/ul>\n\n\n\n
Below, another sample of SelectColuns for reference.<\/p>\n\n\n\n
![\"\"](\"https:\/\/SUMMALAI.COM\/wp-content\/uploads\/2021\/10\/SelectColumns-1024x576.png\")
<\/figure>\n\n\n\nContinue 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.<\/p>\n\n\n\n
![\"\"](\"https:\/\/SUMMALAI.COM\/wp-content\/uploads\/2021\/10\/SUMMARIZE-1024x576.jpg\")
<\/figure>\n\n\n\nNow, you can see the records is reduced from 540K to only 30K rows.<\/p>\n","protected":false},"excerpt":{"rendered":"
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 Read More<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"footnotes":""},"categories":[10,621],"tags":[924,923,925],"class_list":["post-3716","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-power-bi","tag-create-a-new-table-from-another-table","tag-create-a-new-table-with-partial-columns-from-another-table","tag-power-bi-create-a-new-table-from-another-table"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t