Create a subset of the table in Power BI and add calculations using SELECTCOLUMNS DAX Function

Previously I explained the AddColumns function as a function that adds one or more columns to the existing table, In this article and video, I'll explain another similar and useful function with slightly different behavior: SelectColumns, and you will learn how you can use it in Power BI and DAX.
Download the Power BI file from my blog here:
radacad.com/create-a-subset-o...
*******************
Want to learn about Power BI or AI? or take your Power BI and AI knowledge to the next level for building reports? Check out our courses in RADACAD Academy for all aspects of Power BI and AI.
RADACAD courses: learn.radacad.com
Become an academy member: learn.radacad.com/academy/
*******************
********
CONNECT with US!
********
-- / radacad_com
-- / rad_reza
-- / leila_etaati
-- / radacad
-- / leila-etaati-b0304636
-- / rezarad
-- / 6393399
-- radacad.com
********
#PowerBI #PowerBIfromRookieToRockStar #PowerQuery #DAX #Visualization #RADACAD

[@alexrosen8762]

Very well explained.

[@Alireza-ih5vu]

Perfect

[@fatjanpaloja9182]

Great Reza.
I see often that Power BI engine uses Summarizecolumns when I copy query from performance analyzer for analyzing in Dax Studio. Could you show us please a difference of Summarizecolumns and Selectcolumns in an example ?
I know that Summarizecolumns can take a columns from all dimTables and create a virtual table on which a measure can be calculated.
My question is are they similar and which to use (Summarizecolumns;Selectcolumns) in what situation.
Thank You for this valuable informations.

[@nishantchawla333]

summarizecolumns are known to improve the performance.