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.
Hi Greg_Deckler and v-jiascu-msft,
I have tried both possible solutions. But it does not seem to work.
With both solutions I get the following result:
It seems like my date dimension does not filter properly even though I've got a slicer on it and the relation setup between both date columns in the tables.
I cannot create a different date dimension using
Table = CALENDAR(date(2018;1;1);Date(2019;1;1)
since both values are variables depending on the users choice. I cannot simply say that the start date is in 2018 since it can also be somewhere in 2019. The same goes for the end date.
Is there an alternative?