Forum Discussion
MTD for Previous period
If the current MTD is the 1-28th of May, I would like to be able to see the MTD sales for the same period for the 1st-28th of January or any other month. Greatly appreciate it if someone can ...
Hi， Anonymous ；
You could create a measure such as:
measure = CALCULATE(SUM('Fact'[amount]),FILTER('Table',DAY([Date])>=1&& DAY([Date])<=DAY(TODAY())))I tested it, when today is 2022-6-1.so the result is:
when change the today is 5-28.
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-yalanwu-msft
Community Support
Community SupportHi， Anonymous ；
You could create a measure such as:
measure = CALCULATE(SUM('Fact'[amount]),FILTER('Table',DAY([Date])>=1&& DAY([Date])<=DAY(TODAY())))I tested it, when today is 2022-6-1.so the result is:
when change the today is 5-28.
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.