Forum Discussion
Sum + DatesInPeriod didn't work.
Hi guys, I tried to show 3 previous months from the selected month using DatesInPeriod function but it didn't work well. My measure is: Total Stock Value last 3 month = CALCULATE( Sum('...
See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008
Thank you! But I don't think that can be work. I've tried my measure to another database and it's ok. The problem here is I don't understand what's wrong with this data.