I am very new to power BI and have taught myself most everything I know by searching the internet but I have come across something I apparently do not understand because I have tried repeatedly to make this work. I have data from a work order system that has Request date, Start, Finish, Comp, and Closed dates. I have been requested to put the data in the format of the visual below. There are many types of work and this needs to be just the CM work type. In order to make this I have a Date table and have copied the table displayed 3 times and made relationships to each of the dates. Request Date, Start, Comp. I then am counting the dates and filtering the page to just CM work type but the data that is displayed is simply not correct. I very much would like to be ask anyone if they can help me out with this issue.
Helpful resources
Join our Fabric User Panel
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Power BI Monthly Update - February 2026
Check out the February 2026 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
