Loose my column dates when adding values or rows in matrix

This is the solution to this topic posted by TheoC 

Okay, so I figured out what the cause is.  The Date field in your Calendar table is fine. But the Date field in your Fact table is actually a DateTime field.  You need to create a Date field on its own and then create a relationship between the two tables with the Date fields only  

Hi ctedesco3307 

Glad I could help with the "Okay, so I figured out what the cause is.  The Date field in your Calendar table is fine. But the Date field in your Fact table is actually a DateTime field.  You need to create a Date field on its own and then create a relationship between the two tables with the Date fields only "

In all honesty, I don't know the exact reason that the Date and Date/Time didn't work initially.  It could have been for a variety of reasons but within this example, I am unsure.

All the best with your Power BI journey my friend.

Theo 🙂