Forum Discussion
Solved
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 ...
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.
lkalawski
Resident Rockstar
Resident RockstarHi SandipGhosh ,
This is explained in the Remarks section: https://dax.guide/selectcolumns/
Please check it.
_______________
If I helped, please accept the solution and give kudos! 😀
Hi,
it stated that "SELECTCOLUMNS starts with an empty table before adding columns." I dont understand what does it mean?
Can you explain me that?