Forum Discussion
Running Totals
Brendy_P Seems like you understand things correctly. Looks like you are calculating a measure called Sales. You first break out of filter context by using ALL. Then you impose your own filter context where you are retrieving the last 30 days. So the maximum date in context and then back 30 days from there.
I personally avoid time "intelligence" functions if possible. You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000
Also, see my Time Intelligence the Hard Way:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008
Hi, Brendy_P
Yes, no problem at all. DATESINPERIOD function and the filter conditions both return the same date range.
Although, each function has its own usage, you can tweak and change the expression to get the same result as another function.
Best Regards,
Community Support Team _ Eason