Forum Discussion

aparodi's avatar
aparodi
Frequent Visitor
10 years ago
Solved

DAX - How calculate a Running Total 2 from previous Running Total 1

Hi,   I need create a measure (Running Tot2) that calculates running total based on an earlier measure  that calculates the a previous running total (Running Tot1)   PM Sales := sum(Sales[Current...
Need Help
  • aparodi's avatar
    aparodi
    10 years ago

    After various tests, I found a solution. :smileyvery-happy:

     

    Running Tot2 = SUMX(FILTER(ALLSELECTED(DimTime[Date]),DimTime[Date] <= MAX((DimTime[Date]))),[Running Tot1])

     

    2015-11-24_12-03-55.png

aparodi's avatar
aparodi
Frequent Visitor
10 years ago

After various tests, I found a solution. :smileyvery-happy:

 

Running Tot2 = SUMX(FILTER(ALLSELECTED(DimTime[Date]),DimTime[Date] <= MAX((DimTime[Date]))),[Running Tot1])

 

2015-11-24_12-03-55.png

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Thank you so much for this post.

 

I had a similar scenario where I had 2 measures.

 

Measure 1 had values from the start of a month up to a certain date and blank values after that date.

Measure 2 picks up from where Measure 1 stopped.

I created Measure 3 to combine the 2 and when I created a cumulative value based on Measure 3, the cumulative only worked to tne end of Measure 1.

 

Using your SUMX formula worked :smileyhappy: