Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
54 | |
23 | |
19 | |
18 | |
17 |
User | Count |
---|---|
91 | |
87 | |
47 | |
30 | |
22 |