Forum Discussion
Time Intelligence (Beginner Help Please!!)
Hi learning_dax ,
I think your dax code is correct. The issue should be caused by your date table. How did you get your Date table, by Enter Data or calculated table by calendar/calendarauto dax function? To succeed to use time intelligence, please make sure your date table has continuous dates in it. I suggest you to use calendar/calendarauto dax function to create a date table with continuous dates.
For reference: Create date tables in Power BI Desktop
Below screenshot is my test result. Top table show the correct results based on continuous date table. Below one show incorrect result based on uncontinuous date table.
You may download my sample to learn more details.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
There's only two tables, and the relationship is one to many, the many side being my fact table. It is joined via my [Date] key on my Date table and [Customer Visit Date] on my fact table.
Hi learning_dax ,
I think your dax code is correct. The issue should be caused by your date table. How did you get your Date table, by Enter Data or calculated table by calendar/calendarauto dax function? To succeed to use time intelligence, please make sure your date table has continuous dates in it. I suggest you to use calendar/calendarauto dax function to create a date table with continuous dates.
For reference: Create date tables in Power BI Desktop
Below screenshot is my test result. Top table show the correct results based on continuous date table. Below one show incorrect result based on uncontinuous date table.
You may download my sample to learn more details.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.