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

     

v-diye-msft's avatar
v-diye-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous 

 

This could help:

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi v-diye-msft 

     

    Can we achieve this via Calculated Column instead of Measure?

     

    Regards,

    Prakash