Forum Discussion
Handling blank values between dates
Hello, I've got a problem with handling blanks between two dates. I've got a measure that sums up the amount of hours in my fact table. This is filtered by a relative date slicer. The picture b...
I have fixed my issue by not using a date hierarchy but just a calculated column with year and month instead.
I could then use the "show items with no data" option.
Many times you can fix this by moving your calculations to VAR's and then have a return RETURN like:
IF(ISBLANK(__SomeVar),0,__SomeVar)