Forum Discussion

PeRoma's avatar
PeRoma
Frequent Visitor
2 years ago

create column with DAX using paramters as identifier for column

Hi all,   I would like to copy a column using DAX. The problem is that the column is selected as a parameter. Example: Nummer AA    BB    CC 1 123 111   2   222   3 345     ...
StrategicSavvy's avatar
StrategicSavvy
Icon for Resolver II rankResolver II
2 years ago

Hi,

I think it is not possible in DAX to reference dynamically columns in calculatd tables because they always need to have data copied. I think If you want this you will need to copy all the columns AA, BB, CC and then you can dynamically reference this new calculated table. 

 

Hope it helps!

PeRoma's avatar
PeRoma
Frequent Visitor
2 years ago

Hi Savvy,

Thank you for your reply. I was afraid that this would not be possible. But gave me some hope that I can reach my final goal: My goal is, to compare the columns. In the example above there would be TRUE for row 4, 9 and 16 when comparing AA wigh BB. Is it possible to do this comparison e.g. via function EXACT and reference the columns at run time?

Thank you once more for your reply.

Best regards

peroma