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'm having trouble with some dax. This is working as expected for a month with values and returning the prior date. If the current Month/Year does not have a value, it will return the prior month/year. What I am having trouble with is returning the value for that period. For example, May 2023 has no value but we can see that April 2023 has a value. I would like to display the April 2023 value or the previous value until there is a value with a date that is >= selected date.
April Value
Solved! Go to Solution.
You can modify your code which returns the date to use LASTNONBLANKVALUE instead of LASTNONBLANK.
You can modify your code which returns the date to use LASTNONBLANKVALUE instead of LASTNONBLANK.
This did work with one caveat. On the report, the date filter needs to use the full date key, for example dimdate[date] vs dimdate[monthyear]. Thank You.
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 |
---|---|
47 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
76 | |
50 | |
46 | |
16 | |
12 |