The SELECTCOLUMNS function simply takes some column\/columns from another table and create a new table from them.<\/p>\n\n\n\n
For example, you can take only one column, Revenue, The syntax of SELECTCOLUMNS is simple:<\/p>\n\n\n\n
Smaller table = SELECTCOLUMNS(Table1;”This day revenue”;[Revenue]) For Example:<\/p>\n\n\n\n And, if we need to add a filter:<\/p>\n\n\n\n The SELECTCOLUMNS function simply takes some column\/columns from another table and create a new table from them. For example, you can take only one column, Revenue, The syntax of SELECTCOLUMNS is simple: Smaller table = SELECTCOLUMNS(Table1;”This day revenue”;[Revenue]) It is the new table name, column name in the new table, column name in the original 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,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[10,621,625],"tags":[1038],"class_list":["post-3909","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-power-bi","category-sql","tag-distinct-with-multiple-columns"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t
<\/strong>
It is the new table name, column name in the new table, column name in the original table, column name in the new table, column name in the original table…)
If you need unique value only, not all rows, you may use DISTINCT.<\/p>\n\n\n\n\nDISTINCT(\nSELECTCOLUMNS('Dim_Products',\n'Dim_Products'[SaleCode], \n'Dim_Products'[ProducttName], \n'Dim_TimeZone'[StartDate], \n'Dim_TimeZone'[StartTime], \n'Dim_TimeZone'[EndDate], \n'Dim_TimeZone'[EndTime], \n'Dim_TimeZone'[Variation]))<\/strong><\/code><\/pre>\n\n\n\n\nDISTINCT(\nSELECTCOLUMNS(\nFILTER('Dim_Products', 'Dim_Products'[SaleCode] = 123 && ('Dim_Products'[ProducttName] = \"ABC\" || 'Dim_Products'[ProducttName] = \"XYZ\" )),\n'Dim_Products'[SaleCode], \n'Dim_Products'[ProducttName], \n'Dim_TimeZone'[StartDate], \n'Dim_TimeZone'[StartTime], \n'Dim_TimeZone'[EndDate], \n'Dim_TimeZone'[EndTime], \n'Dim_TimeZone'[Variation]))<\/strong><\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"