Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Dynamic column name from its value

Hi   Is there any way to dynamically change column name from its values. I think it might be possible using advanced editor, but i'm not very good at writing M.   I have Dimension table and i wan...
  • MarcelBeug's avatar
    MarcelBeug
    9 years ago

    Watch this video in which "Source" is the name of the previous step in my query.

    Unfortunately, while typing, it jumped from the second line to the first line, but it is the same "Source".

     

pager's avatar
pager
Frequent Visitor
9 years ago

Thanks, that video makes much more sense!

 

Would there be a way to utilize a Switch or IF function for the name based on a slicer? Hypothetically, if I had a slicer based on Seasons of the year, I would want my columns to reflect the names of the month in that season.

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi pager,

Would there be a way to utilize a Switch or IF function for the name based on a slicer? Hypothetically, if I had a slicer based on Seasons of the year, I would want my columns to reflect the names of the month in that season.

As far as I know, it is not possible to do it currently. :smileyhappy:

 

Regards