cancel
Showing results for
Did you mean:
Helper IV

## 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.

Thank you.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support

## Re: Comparative last 30 days

To use measure, you could refer to DAX below.

```Measure =
LOOKUPVALUE ( Sheet1[Active Users], Sheet1[Date], MAX ( Sheet1[Date] ) - 30 )
```
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 REPLIES 5
Community Support

## Re: Comparative last 30 days

You may use LOOKUPVALUE Function to add calculated columns.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper IV

## Re: Comparative last 30 days

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

New Member

## Re: Comparative last 30 days

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

Highlighted
Helper IV

## Re: Comparative last 30 days

Can not with measure?

Community Support

## Re: Comparative last 30 days

To use measure, you could refer to DAX below.

```Measure =
LOOKUPVALUE ( Sheet1[Active Users], Sheet1[Date], MAX ( Sheet1[Date] ) - 30 )
```
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

#### ‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

#### Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors