Forum Discussion
Resolver IILoose 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 🙂
Resolver IIHi TheoC - Ok - I took your suggestion one step further and created a date columns using Datevalue(worklog_worklog_date) and that worked! So I ammend my above post to confirm you provided the correct solution, although i don't understand why both TDate and Worklog_Worklog_Date being date/time or both being Date don't work. That doesn;t make sense to me. If you can explain that - would be super helpful - if not - ok. THANK YOU for the solution.