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.

Gavin_Shales's avatar
Gavin_Shales
Frequent Visitor
8 years ago

 

 

 

Hi Taico,

 

Hopefully you can see my Pic which i have added.

 

Basically, it's not liking the "Earlier" part of the code. It says, "Earlier/Earliest referes to an earlier row or context which doesn't exist"

 

Should I be using this code in a "New Measure"?

 

Thanks

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