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
I have a measure with today's date D 0 and a measure with yesterday's date D -1.
How can I get dynamic when I filter a date on a slicer?
For example, when selecting on filter day 26 bring in D 0 result of day 26 and in D -1 result of the previous day 25
If I select on filter day 25 bring in D 0 result of day 25 and in D -1 result of the previous day 24 And so on. Can someone help me?
thanks
Please refer to the steps below to achieve your requirement.
Result.
Regards,
Charlie Liao
Thanks for the example, it worked well.
But it still is not what I need.
I need to separate. A measure that contains today's date, and a measure that contains yesterday's date according to the date filter.
Then check the variance in the graphs between the two results.
Thanks
Have a read of my article here https://exceleratorbi.com.au/dax-time-intelligence-beginners/
Thanks,
But I'm really not able to put the formula all filter, or filter allselect in the formula with SUMX
Please can anyone help me, structure the code for d-1. What to get yesterday's filter date?
@sakamotothais wrote:
But I'm really not able to put the formula all filter, or filter allselect in the formula with SUMX
You can extract yesterday's filter date generally by using the piece of code MAX(Calendar[Date])-1 where Calendar[Date] is used to filter your visual. It is normally used inside a calculate
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 |
---|---|
113 | |
100 | |
77 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |