Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Hi @amfc
To achieve your goals you can add a Flag column, that returns 1 if it previous date:
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:
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
That is perfect.. Thank you for your help
I was happy to help😊
Hi @amfc
To achieve your goals you can add a Flag column, that returns 1 if it previous date:
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:
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
97 | |
75 | |
63 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |