Forum Discussion

Optimusprime_25's avatar
Optimusprime_25
Icon for Resolver I rankResolver I
3 years ago
Solved

How to Sort Sub Header in Switch Case in DAX

I have to sort the sub header columns 

values =
var ABC_MTD
var ABC_YTD
var XYZ_MTD
var XYZ_YTD
RETURN
SWITCH(
MAX(Table[Sub_Header]),
"MTD", ABC_MTD,
"YTD", ABC_YTD,
"MTD", XYZ_MTD,
"YTD", XYZ_YTD)
 
Above we are able to create the measure but while pulling this values MTD and YTD values are not correct because it has same value for bpth columns.
 
how to sort or differentiate here without changing the column names. As it should be MTD and YTD for both columns.
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Optimusprime_25's avatar
    Optimusprime_25
    3 years ago

    I have found the solution for this topic.

    In above case we have sub headers are repeating as MTD and YTD for 8 columns.

    What we did was in switch function we have used space for MTD and YTD so that each and every sub ehader will be unique

     

    Ex: 1. "MTD", "YTD"

         2. " MTD", " YTD"

         3. "  MTD", "  YTD"

     

    We have given extra space so that dax considers each sub header as unique and sort accordingly.

2 Replies

  • Optimusprime_25's avatar
    Optimusprime_25
    Icon for Resolver I rankResolver I
    3 years ago

    I have found the solution for this topic.

    In above case we have sub headers are repeating as MTD and YTD for 8 columns.

    What we did was in switch function we have used space for MTD and YTD so that each and every sub ehader will be unique

     

    Ex: 1. "MTD", "YTD"

         2. " MTD", " YTD"

         3. "  MTD", "  YTD"

     

    We have given extra space so that dax considers each sub header as unique and sort accordingly.