Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Cumulative Total based on YTD figures

Hello all,   I hope you are fine. I am currently struggling with a formula in PowerBI and I need some help. What I try to achieve is to compute the cumulative total of my data. However, my data a...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Dear Janey,

     

    Thanks for your help.

    However, It's not working either when adding this filter.

    But, I have realized that when I use in the slicer the "YEAR" from the table [Vision] instead of the "YEAR" from [Calendar], the formula is working fine.

    Which is "half" a solution since I prefer to use the YEAR from the calendar.

     

    Thanks for your help,I will however keep this in mind for another time I guess.

     

    Best regards,

     

    Guillaume

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

 

The idea is to create one column to have monthly or quarterly data and then use cumulative or YTD logic has per need