Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a table that contains Date values, I have also generated a separate Calendar table to make reporting better but I cant seem to join the two tables.
I've tried different date formats but it doesn't seem to work. I'm stuck.
Solved! Go to Solution.
The two columns need to be the same data type. It looks like it's Date in one table and DateTime in the other.
Proud to be a Super User!
The Calendar table in your screenshot appears to be blank.
Proud to be a Super User!
That's the problem. The Calendar table isn't actually blank. But when I try to make a relationship it appears to be.
@longishrope what happens if you go to the relationships tab and just create the relationsship by draggin Date from your fact table to the Date field in your Calendar table?
The two columns need to be the same data type. It looks like it's Date in one table and DateTime in the other.
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
77 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |