In this video I explain how to create a matrix that displays the number of records that met different milestones during a root cause analysis investigation. The milestones achieved are stored as different date fields in each RCA record.
I apply the USERELATIONSHIP DAX Function to create measures that return the number of records that met each milestone over a period of time in order to understand the level of activity and the flow of RCA investigations through the RCA process.
I use RCA records but this approach can be applied to any records that has multiple milestone dates in each records that represent the completion of a milestone.

Video explaining why you should use a dates table and how to set one up.
youtu.be/exq8AVNCHTY

-------------------------
Free Resources
-------------------------
👉FREE (for a limited time) course on building a Power BI Work Order Backlog Analysis Dashboard
effectivedashboards.com/power-bi-quick-start-create-a-pbi-dashboard-in-90-minutes/

👉Access to the source PBIX files for my Youtube videos:
effectivedashboards.com/courses/free-resources/

👉Article series on creating a maintenance management system data model and how to address the human factors of data collection for improved data quality. (This is not just relevant to maintenance and reliability data).
effectivedashboards.com/data-articles/

• Power BI DAX USERELATIONSHIP() - Example 2 - Working with Records with Multiple Milestone Dates ( Download)
• Handling Multiple Dates in Power BI With DAX [2022 Update] ( Download)
• Using USERELATIONSHIP in DAX ( Download)
• DAX Fridays! #183: How to deal with multiple dates in Power BI ( Download)
• Using USERELATIONSHIP to Activate Inactive Relationships ( Download)
• DAX for Power BI: USERELATIONSHIP ( Download)
• USERELATIONSHIP Function in DAX ( Download)
• USERELATIONSHIP() in Power BI ( Download)
• Multiple Date Functions With VALUES (DAX) ( Download)
• Dealing with Multiple Date Fields to bring values from same time period in Power BI | MiTutorials ( Download)
• DAX Fridays! #21: USERELATIONSHIP ( Download)
• How to use DAX USERELATIONSHIP() - Example 1 - Non-date example. Using a common category axis ( Download)
• USERELATIONSHIP Function in DAX ( Download)
• Power BI Using Inactive Relationships | Userelationship in PBI | Two Join Conditions between tables ( Download)
• USERELATIONSHIP - DAX Guide ( Download)