cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Frequent Visitor

## Measure PreviousDay on Filter

Hi Team,

I have the @easure  PreviousDay = TODAY()-1

And when i try to apply this measure on the filter of the page is not possible...

My goal is to present the value of previous day on a card. When the automactily update run, the PreviousDay measure is updated and the card also..  How can i do it?

 Day Productivity 21/05/2023 6 22/05/2023 5 23/05/2023 6 24/05/2023 1

Thanks

1 ACCEPTED SOLUTION
Super User

Hi @amfc
To achieve your goals you can add a Flag column, that returns 1 if it previous date:

DayBeforeToday = if('Table'[Day]=TODAY()-1,1,0)

From that point, if you need all pages to be filtered by the previous day , put it as a page-level filter

Or if it is relevant only for 1 measure use it as a filter in Dax formula:

Productivity on previous day = CALCULATE(sum('Table'[Productivity]), 'Table'[DayBeforeToday]=1)

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

3 REPLIES 3
Frequent Visitor

That is perfect.. Thank you for your help

Super User

I was happy to help😊

Super User

Hi @amfc
To achieve your goals you can add a Flag column, that returns 1 if it previous date:

DayBeforeToday = if('Table'[Day]=TODAY()-1,1,0)

From that point, if you need all pages to be filtered by the previous day , put it as a page-level filter

Or if it is relevant only for 1 measure use it as a filter in Dax formula:

Productivity on previous day = CALCULATE(sum('Table'[Productivity]), 'Table'[DayBeforeToday]=1)

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors