Period To Date Cumulative Total (Time Intelligence)

[Greg]

Related Content:

Below are a few examples of issues related to the Period To Date Cumulative Total DAX pattern from the eDNA resources.

Enterprise DNA Forum (Search):

Cumulative total for "selected week"

Yes number 2 is just not possible. You need to start using FILTER. Here’s some good examples.

Projecting current profit run rate

Hi Robert, The formula as is is dynamic, in that it will calculate the total cumulative sales over any period and then divide that by the number of days where there were sales Avg. Daily Run Rate (Dynamic) = VAR DaysWithSales = CALCULATE( COUNTROWS( Dates ), FILTER( ALLSELECTED( Dates ), [Total Sales] > 0 ) ) VAR CumulativeTotal = CALCULATE( [Cumulative Sales], ALLSELECTED( Dates ) ) RETURN DIVIDE( CumulativeTotal, DaysWithSales, 0 ) The one thing with this formula is that the numbers are n…

Cumulative Sales TD (non std calendar)

Please refer to your other forum threads. This all comes down to getting a proper date table into your model.

Enterprise DNA TV (YouTube):

Cumulative Totals Only Up To Specific Dates - DAX Tutorial For Power BI

Cumulative Totals Only Up To Specific Dates - DAX Tutorial For Power BI

Show Cumulative Totals Unaffected By Date Slicer Selection In Power BI

Show Cumulative Totals Unaffected By Date Slicer Selection In Power BI

Dynamically Compare Monthly Information Cumulatively in Power BI w/ DAX

Dynamically Compare Monthly Information Cumulatively in Power BI w/ DAX