Forum Discussion
Return prior value if no value exists for current Month/Year
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
You can modify your code which returns the date to use LASTNONBLANKVALUE instead of LASTNONBLANK.
2 Replies
- johnt75
Super User
You can modify your code which returns the date to use LASTNONBLANKVALUE instead of LASTNONBLANK.
- robertpayne21Frequent Visitor
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.