Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to display two calculated columns in matrix

Hi Team,   Could you please help me on below scenorio. I have created the DAX function by using SWITCH function.please find the DAX column below. When i use below calculation in Matrix, its summi...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi Anonymous 

     

    Not sure if I understand your requirement but I think you can create an extra column in your table that concatenates state and category and later use it as Matrix column.

    New Column = table[state] & "-" & table[Category]

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn