topic My calendar date and fact data date are conflicting in DAX Commands and Tips

My calendar date and fact data date are conflicting

Diportee97 — Tue, 25 Mar 2025 11:42:53 GMT

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

Re: My calendar date and fact data date are conflicting

Deku — Tue, 25 Mar 2025 11:58:48 GMT

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

Re: My calendar date and fact data date are conflicting

xifeng_L — Wed, 26 Mar 2025 03:36:32 GMT

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~