Comparative last 30 days

[jracer007]

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/spreadsheets/d/1jvF4xmXOE_TdBfGvwsJNWVqFMpUcoht5wGm_9Gf9hJI/edit?usp=sharing

Thank you.

[v-chuncz-msft]

@jracer007,

You may use LOOKUPVALUE Function to add calculated columns.

[jracer007]

Could you help me please with the formula, I'm a novice in this

[gyro85]

Create new column

Previous Value = LOOKUPVALUE(Sheet1[Active Users],Sheet1[Date].[Date],Sheet1[Date].[Date]-30)

Change the -30 to however many days or parameterise it

[jracer007]

Can not with measure?

[v-chuncz-msft · Accepted solution]

@jracer007,

To use measure, you could refer to DAX below.

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