Forum Discussion
Cumulative Total
Is this what you are looking for?
Hi Ashish_Mathur ,
Thank you for your response. I tried the way you suggested and created one calendar table from the date which needs to be taken as a refernce and created 3 measures as per your suggestion Total, YTD ,Measure however as soon i dragged the "Measure" column in the table its not giving me the correct result instead of this no of rows has been multiplied .
I need cumulative data untill today's date and if date is of future then data shoudl remain same for that date :
Please see below :
Solution which i am looking for is:
Hi,
I can help further only when i get access to the PBI file.
Hi,
i am not sure how to share the pbix here as i dont see any option 😞
Regards,
Ashish
Upload the file on Google Drive and share the download link.
Please see below access of power bi file and let me know if you can able to access it .
https://drive.google.com/file/d/1aIC-S_0Lb3ywiQfE-iyEdDXhItk1Q9JN/view?usp=sharing
Thanks,
Ashish