Help with matrix

[LFM]

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:

[amitchandak · Accepted solution]

@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

[rajendraongole1]

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.