Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Return last non blank value

Hi everyone,    I have the following table:   Indicator Date Value1 Value2 x 01/01/2022 1 2 x 01/02/2022 2 3 x 01/03/2022 4 5 x 01/04/2022 6   y 01/01/2022 7 8...
  • Syk's avatar
    Syk
    4 years ago

    Try this..

    Measure = 
var maxdate = CALCULATE(MAX('Table'[Date]),'Table'[Indicator] = "x", NOT ISBLANK('Table'[Value2]))
return CALCULATE(MAX('Table'[Value2]),'Table'[Date]=maxdate,'Table'[Indicator] = "x")

     

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Anonymous 

Value1 and Value2 are measures or columns? How are going to disply thhe result?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Value1 and Value2 are calculated columns of the table. I want to have conditional markup based on the requested value, so I need it returned as a singular value.

    • tamerj1's avatar
      tamerj1
      Icon for Community Champion rankCommunity Champion
      4 years ago

      Anonymous 

      Check Syk  solution. It should provide the desired result.