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 Community Sticker Challenge - Barcelona 2026
If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!
Power BI Monthly Update - July 2026
Check out the July 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.
