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)
	)
)
stackover's avatar
stackover
Frequent Visitor
2 years ago

Thanks @Ahmedx and Anonymous but it is looking weird in the graph. I put my real data table in the .pbix file and the graph does not show a crescent line like in a running total line. As I don't have any negative number, it should be a crescente line, like and near to the orange line as this image below.



Here is the link to the pbix file.

 

https://we.tl/t-lpyUCADjtt