Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Last Year Total in Matrix

Hi,   I have used Matrix to have a YTD reporting in my PBI report and it is great to see the current year total can be easily displayed.   My question is, if my data set is like below in the seco...
Need Help
  • v-alq-msft's avatar
    v-alq-msft
    5 years ago

    Hi, Anonymous 

     

    You may remove 'Month' from 'Column'. Here is the result.

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
5 years ago

Anonymous Do you have a date dimension in your model? i

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Yes like below.