Changing the column name in Dax by the user.

[Rbrt09090]

Is there a way that the user can select the column DAX is using in a calculated column? I tried slicers and binding the parameters but i cant get anything to work. 

Through slicers a user can select a defined value and a measure can collect the selected value but is seems that data cannot be used as a filter or as a part of a calculated column. I tried that the <logical_test> from the IF statement comes from a slicer selected value but the format is apparently different. 

Last i created 4 colums with the different IF statements in it, and create a calculated column with the name of the column that should be used. I put the calculated column as filter page so the data is filtered correct. But no i want that the user can somehow change the column that is used in the calculated column, is this possible?

Filter =

VAR Field = [Filter01]

return

Field

"The [Filter01] is the one i want to be changed by the user, because when i change it manully it works fine".

[Anonymous]

HI @Rbrt09090,

Nope, I don't think it is possible to use Dax formula and filters to control calculated field names.
Regards,

Xiaoxin Sheng

[amitchandak]

@Rbrt09090 , If you trying to a slicer value in a calculated column, that is not possible. You need to create a measure in that case