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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.
Fabric Community Update - June 2025
Find out what's new and trending in the Fabric community.
