Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
My date relationship isn't working between my two tables and I can't figure out why!
They are both the same data type and format:
And the relationship is exactly what I would expect it to be..
Have I missed something??
Hi @khaycock ,
Please tell us why you think "Date Relationship not working"? Is there a specific performance?
Please provide some sample data and screenshots. Please remove sensitive information.
Best Regards,
Icey
@khaycock , There can be a couple of reasons. Form completion time has a datestamp and visible because of format. Change to datetime and format that has time and check. If has tome other than 12 AM. create a date field and join that
Form completion Date =[ Form completion time].date
Second that you might have used all or crossfilter in the formula. that can cause that
Hi @khaycock ,
If I see your screenshot, I see that Power BI has crrectly identified a MANY-to-ONE relationship between both tables.
Just wanted to understand why you think the relationship is not working?
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 41 | |
| 39 | |
| 37 | |
| 29 | |
| 24 |
| User | Count |
|---|---|
| 118 | |
| 98 | |
| 70 | |
| 69 | |
| 65 |