Forum Discussion
SandipGhosh
6 years agoFrequent Visitor
What is the difference between addcolumns and selectcolumns in DAX?
Hi, We all know that both addcolumns and selectcolumns have almost the same syntax and return a table, but I want to know that What is the difference between addcolumns and selectcolumns in DAX? is ...
- 6 years ago
SandipGhosh , In case, addcolumn, exiting column are already selected and you add post that. The column that are there in table part of the addcolumn.
Selectcolumn is select each column/formula with a new name. There is nothing selected beforehand.
garythomannCoGC
Impactful Individual
3 years agoCreate a subset of the table in Power BI and add calculations using SELECTCOLUMNS DAX Function
And further the above article makes it all very clear :}