Running Totals

Question

Hi&nbsp;I have the solution but want to understand the logic of the solution, below is the formula with the logic of what I think the formula is performing. Can someone correct me in understanding the logic or am I correct.&nbsp;Running Total (Filter) = CALCULATE([Sales],FILTER(ALL(Full_Date_Table),-- We are going to filter the full dates table but before we do make sure all the filters are clearedFull_Date_Table[Date]&gt;MAX(Full_Date_Table[Date])-30&amp;&amp;-- If the date in the filter context is &gt; to the date(s) of the Max date in the filter context then go back 30 days (MAX is a scalar Function) ANDFull_Date_Table[Date]&lt;=MAX(Full_Date_Table[Date]))) -- If the date in the filter context is &lt;= to Max date in the filter context then Calculate sales &nbsp;I know I can create the same formula with&nbsp;Running Totals (DatesInPeriod) = CALCULATE([Sales],DATESINPERIOD(Full_Date_Table[Date],MAX(Full_Date_Table[Date]),-30,DAY))&nbsp;But I want to get my head around how the first formula works.&nbsp;Thanks for your time

greg_deckler · Accepted Answer

Brendy_P&nbsp;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.&nbsp;
&nbsp;
I personally avoid time "intelligence" functions if possible.&nbsp;You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000Also, 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

Forum Discussion

Running Totals

2 Replies

Related content

Running Totals

Running total

Waterfall Charts with running totals

Tableau to PowerBI Running Totals Issue

SumX? - cumulative running total