Forum Discussion
Time intelligence does not work properly
First of all, great job providing the community with the tools needed to help you troubleshoot!
My best guess is that your SalesHistory[InvoiceDate] is actually a datetime data type instead of just date.
If you have a time portion in the date, it's highly unlikely that the InvoiceDate will match your calendar table...1/1/2018 5:03:14 AM is not the same as 1/1/2018 12:00:00 AM (which is what your calendar date will be).
Don't just change the data type in Query Editor. I've run into instances where this step didn't actually truncate the time properly.
Highlight the [InvoiceDate] column, click on the transform tab, click on the highlighted Date button, and click "Date only".
That should truncate the time portion off.
Have you also marked the date table as a date table, not sure about creating models directly in PowerBi, but Time Intelligence wont work in SSAS unless you mark it first.