Question

You are building a Power BI model with a fact table named Sales and a separate Calendar table containing one row per day covering all sales dates. You create a measure using TOTALYTD, but it returns incorrect year-to-date results and Power BI shows a warning that automatic date/time intelligence may not work reliably. The Calendar table has a proper Date column of type Date and a one-to-many relationship to Sales[OrderDate]. What should you do to ensure the time intelligence functions calculate correctly?

Accepted Answer

Use the Mark as date table feature on the Calendar table and specify its Date column as the date key

Answer

Enable the Auto date/time option in the model's global settings so a hidden date hierarchy is created

Answer

Change the relationship between Calendar and Sales to a bidirectional cross-filter direction

Answer

Set the summarization property of the Calendar[Date] column to Do not summarize