Forum Discussion

LFM's avatar
LFM
Helper III
2 years ago
Solved

Help with matrix

I want to sum of required margin for different years on the rows and report date on column. But I dont want the text for required margin as column heaaders. 


I want it to look like this:

2 Replies

  • LFM , Check the replay suggested by rajendraongole1 , In case that do work check below

     

    I think you need to use Matrix Property

    Switch value to row

     

  • Hi LFM  - you can use the left function from dax and try

     

     

    Hope it works, try and let know

     

    If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.