Forum Discussion
MTD Total
Hi everyone, I have a table with: Column 1 - Date, Column 2 - MTD sales for the current month (e.g., Jan 2024 until the previous day, for example, 30.01.2024), and Column 3 - MTD sales for th...
Thank you for your answer, I've tried your PY formula but it show me the cumulated total to each date (I have days on rows). I need the MTD PY for each day and in Total field the MTD PY for previous day which is the last day with values.
Hi Stelian ，
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.