Forum Discussion
Date in relationship
I have 2 tables, One is DimDate, other one if FactTable with the date column that has "Date" type . When I make relation between Date columns in these two tables, The type of date column in Fact tabl...
Kedar_Pande
Super User
Super User- Check the data types of both the Date columns. In the FactTable, the Date column should be set to Date type. In the DimDate table, the Date column should also be Date.
- Ensure there are no time values in the FactTable[Date] column before creating the relationship, as Power BI might interpret it as a Date/Time type, which can cause issues.
💌 If this helped, a Kudos 👍 or Solution mark ✅ would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn