Forum Discussion

jracer007's avatar
jracer007
Icon for Helper IV rankHelper IV
8 years ago
Solved

Comparative last 30 days

Hello community, Today I want to ask you for help to build a formula that allows me to compare the value of yesterday's day against that of 30 days ago. My data source: https://docs.google.com/sp...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    jracer007,

     

    To use measure, you could refer to DAX below.

    Measure =
LOOKUPVALUE ( Sheet1[Active Users], Sheet1[Date], MAX ( Sheet1[Date] ) - 30 )
jracer007's avatar
jracer007
Icon for Helper IV rankHelper IV
8 years ago

Can not with measure?

v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
8 years ago

jracer007,

 

To use measure, you could refer to DAX below.

Measure =
LOOKUPVALUE ( Sheet1[Active Users], Sheet1[Date], MAX ( Sheet1[Date] ) - 30 )