Understanding 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.