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!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
I would like to place these two dates ( yellow) in the matrix table and also calcualte the date difference. and also put SKU, SALES MEETING, AND SUPPLIER NAME(pink) from the master table in the matric table in the visual as well. Once I put the date in, it shows no relationship between these two dates and it turns into can't display this visual Please help. very apprecaited and thanks so much !!
You have to delete the relationship on table with report date and calander and create relationship with the master table based on related ID fileds to use the datediff fucntion.
Hi thank you for helping, did you meant I have to delate the relationship for calander and connect signle ID from a dimension table? but still doesnt work, I still cant put these two dates into one table. please see my screeshot
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.