Can I set a column name as variable in DAX?

[Anonymous]

Hi there 🙂

I want to be able to change the column name referenced in a DAX formula - for example here I want to be able to change the column name where it says "YTD", so that this is based on a slicer selection

Its easy enough to change the other values (e,.g. I made a formula that uses a slicer input instead of the hard coded "Turnover" value in the above formula...but I'm wondering if its possible to also make the column name in square brackets a variable? 

Is this possible?

Thank You!!

Alex

[Anonymous]

Thanks very much for this!  Yes I was able to work around this using the SWITCH function.

Thanks again

Alex

[AllisonKennedy]

You're welcome!

[AllisonKennedy · Accepted solution]

@Anonymous Not exactly within the square brackets, but you could try a SWITCH function to get the result you're after: 

Here's an example I made up: 

Test Slicer Column =

SUMX(FILTER('Blank Values',

VAR _Column =

SWITCH(SELECTEDVALUE(Slicer[Column Select])

, "Year", 'Blank Values'[Year]

, "Key", 'Blank Values'[Key])

RETURN

CONTAINSSTRING(_Column ,"2018")), 'Blank Values'[Value])

[perezco]

I know I'm a Very Late to the party. But is it feasible to obtain the pbix example file that does this?

[perezco]

don't worry , I find it how to do it ? 🙂