Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Last Non zero Value based on max date

Hi All   I am trying to get the last charged amount to an id which im running into the issue of getting zeros where the last entry is a zero.   My current formula only looks at the max value base...
Help required
  • Anonymous's avatar
    Anonymous
    6 years ago

    Anonymous Please try below measure. 

    Measure = 
VAR _maxdate = CALCULATE(MAX('Table'[StartDate]),FILTER(ALLEXCEPT('Table','Table'[UnitId]),'Table'[ChargeAmount]>0))
RETURN CALCULATE(MAX('Table'[ChargeAmount]),'Table'[StartDate]=_maxdate)

    If it helps accept as solution. 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anonymous I'm getting below output. I guess this is what you were expecting.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous 

 

Yes that is exactly what i am after!

 

Have i done sopmething wrong within the formula?

 

Kind Regards

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    For closure purposes and in case anyone else has the same issue,

     

    Anonymous solution works, it was my fault for leaving my test measure within the table/matrix. Once these were removed the new measure works.

     

    Thanks again Anonymous  for your help.