Relation between Date and Fact tabl

Hi  ani_informa  ,

In Dax, the date can be of the date or date/time type. You can check whether the data type in your table is one of these two, to prevent it from being a text type, confirm the date column in all your tables ,the data types are all the same.

And if the data type of the date column in one table is "date", and the data type of the date field in the other table is "date/time", an error that does not work will occur.

If my answer is not what you need, can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.