Forum Discussion

Gavin_Shales's avatar
Gavin_Shales
Frequent Visitor
8 years ago
Solved

Using the latest value when a field is blank.

Good day All,   I am look for some help.   I have a table which currently has some missing values and I am trying to populate these missing values with the most recent value at that point in time...
Need Help
  • ForcaTaico's avatar
    ForcaTaico
    8 years ago

    Hi

     

    ValueLast = LOOKUPVALUE(Table1[Value],Table1[Date],CALCULATE(LASTNONBLANK(Table1[Date], 1), FILTER(Table1,Table1[Value]>0 && EARLIER(Table1[Date])>=Table1[Date])))

     

    If you have a Date-table the above formular could be simplified... but it should work.

ForcaTaico's avatar
ForcaTaico
Resolver II
8 years ago

The formular was intented for an calculated column not a measure.

Gavin_Shales's avatar
Gavin_Shales
Frequent Visitor
8 years ago

Thank you very much, Taico. It's working very nicely.

 

Regards

Gavin