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.

MarcelBeug's avatar
MarcelBeug
Community Champion
9 years ago

My knowledge is specifically with Power Query.

 

Otherwise I think you need to clarify your question for DAX/Report experts.

Typically a slicer is used to select data from table rows, not from columns.

So it sounds like a strange request to me, but if you think something should be possible, I think you'd better start a new topic.