My calendar date and fact data date are conflicting

[Diportee97]

 Hello guys,i ran into a slight issue concerning my calendar function..the month function on my y axis are blank and do not return any value,and also my calendar table date and fact data date are not corresponding,my  fact data date only has 2023 dates while my calendar date has 2023 and 2024 dates which has been causing a great conflict in my visuals,what do you think is the best way forward to this?

https://drive.google.com/file/d/1B4evZsPDqjQ7zyLrEty4bZJBUEC63Qdt/view?usp=drivesdk 

Thats the link to the data set for better understanding 

[xifeng_L · Accepted solution]

This happens because the data types of the two fields of the join relationship do not match.

In this case, the date of the fact table is with time, while the date of the date table is without time, so the two don't match, causing the DAX engine to automatically add empty rows.

You can go into PowerQuery and change the data type of the date field in the fact table to Date instead of DateTime.

Or, just change the data type to "Whole Number", then change back to datetime type.

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~

[Deku]

• Go to PowerQuery and set the dates in your fact table to Date type
• Ensure relationship between date and fact table