Forum Discussion
Conditional column and DAX
I need some help with a conditional column and DAX; I have an expense report with 2 measures - 'Expenses Local' and 'Expenses USD'. I have created a single measure – ‘Expenses’ using a SWITCH on a d...
Thanks for the workaround. It does work but it will not be accepted by the business user. It adds an additional column per company and repeats for every row. Unfortunately I cannot mark this as the solution.
Hi MrDavidWilliams ,
Unfortunately, I didn't help you. I find two similar ideas about adding measures into the column field of matrix. You could vote it up to get it fixed quickly.
to be able to add measures on rows and columns at the same matrix
Allow the creater to use a measure as the column headings in a matrix
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.