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.

dilipkumar9's avatar
dilipkumar9
Frequent Visitor
8 years ago

hi Pager .

i am exactly looking for this solution. when i select a month from slicer , i want to see my meaure "revenue" with the month name from slicer. something like "revenue June 2018 ".

were you able to get this working? if so please share?

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Absolut same issue - would be good to have a solution in here. 
    In my example we can switch in a slicer between Money and Volumes. So if user is selection Money in column names should be (EUR) and if selected volumes it should be written (HL).

     

    ...