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

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)
	)
)