Dax Help - Extract Max Date from Table Visual

Community Support

7 years ago

what do you mean based on the condition that value of $ Forecast Remaining being almost ZERO.

Is it the min value or absolute value almost zero?

IF so, you may try to adjust your runningtotal as beow:

RunningTotal = CALCULATE(SUM(Table1[Sales]),FILTER(ALL(Table1),Table1[Date]<=MAX(Table1[Date])))

then create an absolute value of running total

absolute = CALCULATE(ABS([Sales running total in Date]))

and then get the maxdate

maxdate = CALCULATE(MAX(Table1[Date]),FILTER(Table1,ABS([RunningTotal])=[minabsolute]))

Result

here is pbix, please try it.

Best Regards,

Lin

Forum Discussion