Forum Discussion

VanessaCain's avatar
VanessaCain
Regular Visitor
7 years ago

DAX Fill Up - limit

Hi,   I'm working with a large set of daily data that gives prices for the iron ore industry.   I've been given a DAX formula to 'fill up' gaps in my historic data i.e. to roll over the previous ...
parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

VanessaCain the parameter you are passing Date.From(DateTime.LocalNow()) , subtract one day from this using Date.AddDays function, read here about this function.

VanessaCain's avatar
VanessaCain
Regular Visitor
7 years ago

Hi, thank you so much for responding!

 

But will that mean that if e.g. the data is updated at 6:30pm today, it won't appear in my report until tomorrow?

 

Delivering the updated data as soon as it's updated at the source is much more important that back-filling the old dates for the purpose of the tool.

 

Thanks again for your help!

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    7 years ago

    VanessaCain assuming going forward there is no missing data and doesn't require backfill, correct?

    • VanessaCain's avatar
      VanessaCain
      Regular Visitor
      7 years ago

      Thanks again parry2k 

       

      Correct - the missing data is just a historic problem. 

       

      So moving forwards we don't need any fill ups. However, we do need the data be updated as soon as it's updated at the source, rather than the following day....