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))