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
Fabric Data Days 2026
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Power BI Monthly Update - May 2026
Check out the May 2026 Power BI update to learn about new features.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
