Forum Discussion

stackover's avatar
stackover
Frequent Visitor
2 years ago
Solved

Running Total wi

Hi all.    I need help with a DAX formula. I searched and tried a lot but I wan not able to create such measure yet. I need to SUM "value" column where the date in the "Actual" column is the las...
Need Help
  • stackover's avatar
    stackover
    2 years ago

    Never Mind. I was able to solve the problem using the DAX below.

    Value running total in Date = 
VAR _MaxDateInID = CALCULATE(MAX('Project_Baseline'[Actual]),  ALLEXCEPT('Project_Baseline',Project_Baseline[Project ID]))
return CALCULATE(
	SUMX('Project_Baseline',[m1]),
	FILTER(
		ALLSELECTED('Project_Baseline'[Date]),
		ISONORAFTER('Project_Baseline'[Date], MAX('Project_Baseline'[Date]), DESC)
	)
)
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi stackover 

 

Ahmedx  GOOD ANSWER!

 

You can also try the following.

 

Two measures:

maxDate = CALCULATE(MAX([Actual]), ALLEXCEPT(Project_Baseline, Project_Baseline[Project ID]))

 

MH-Baseline = CALCULATE(SUM(Project_Baseline[Value]), FILTER(Project_Baseline, [Actual] = [maxDate]))

 

Best Regards,
Yulia Xu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.