Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Today-1 data for each record

Hi All,   I have two columns date and values. I would like to generate a new column which will show previous days values. How can i achieve that?   Thanks and Regards
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    Hi Anonymous 

     

    This could help:

    Measure 3 = CALCULATE(MAX(Table1[Values]),FILTER(ALL(Table1),[Date]=MAX(Table1[Date])-1))

     

Nathaniel_C's avatar
Nathaniel_C
Community Champion
6 years ago

Anonymous ,

Try this:

Yesterday = 
var _cdate = MAX('Table'[date])
var _calc = Calculate(MAX('Table'[values]),ALL('Table'),'Table'[date]<_cdate)

return _calc

 


Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel