Forum Discussion
Filtering out future dates while not suppressing zeros in visual
This issue was resolved by filtering out future dates in the calculated calendar table.
I recreated your scenario and I do not see an issue. The only thing that i could think of is that there is no relationship between the "date" table and your "data" date table. If there is then I would check that both dates are formated the same way, cause i had run with this issue before where even though the column looks like a date and there is a relationship. When you filter the data it does not take any affect.
This is how i would tested, create a new column that formats your current date to just Y/M/D then create a relationship a new relationship using this new column.
Calendar Format = DATE(
YEAR(table[Date])
,MONTH(Table[Date])
,DAY(Table[Date])
)
This is mine working using the past/future scenario