Forum Discussion
Helper VUnderstanding Date Table and How It Filters
Hi Txtcher ,
Thank you for reaching out to us on the Microsoft Fabric Community Forum.
Yes, the best and most efficient practice is to add a new column to your history table that contains only the date (without the time) and use that for your relationship to the calendar table.
This allows you to:
-
Maintain the original date/time values for analysis that needs time-level detail.
-
Use your calendar table (which only includes dates) effectively in slicers and visuals without needing a massive minute-by-minute calendar.
If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.
-
Helper VThank you for the article link.
Here are screen shots (this is just some sample data for testing and learning purposes).
Calendar table - yes it has at Fiscal Year for each date in the calendar:
The history table is simple (huge, but simple).
Relationships:
This seems like it should be pretty basic and simple, but ...I am clearly lost.
Super UserHi Txtcher
You calendar table should be able to filter your HX table based on the images provided. Please check if:
- calendar covers all dates in HX
- relationship is between the same data types HX[CreatedDate] could be a datetime but appears as date only on data/table view. Note: Type any (ABC123) is also considered a text.