Bug: Time table doesn't filter Steps to replicate bug: 1) I created a simple date table which has date hierarchy 2) Added 1 column "_Year" using Dax function Year(xxx) 3) Added date hierarch...
Hi QC
I got a reply from the PG team:
The Core problem is that the hierarchy internally is a different table that has a one way filter relationship with a date table. So the filter on date table can't filter hierarchy. This is done because the hierarchy might be reused for different dates within model. So they suggested that you could use the year from the hierarchy or change a table to also use calculated columns instead of hierarchy.
Best Regards,
Community Support Team _ Ailsa Tao