Use DAX Relationship for Multiple Dates Columns 

Great video, thanks for sharing!

Extremely helpful video! Than you.

Thank you

What if you need to use a date slicer to filter it!? How can I indicate that the relation will be based on one specific date column!?

Can you take it a step further and show how to pull average days from 40 date columns? I need to create a table that shows two columns Average days from "Cred Paperwork Completed Date to Submitted Date" Per Insurance Carrier Average days from "Submitted Date to Effective Date" Per Insurance Carrier The desired output should look like Pic 1, however, the data is housed in 62 different date columns as previewed in pic 2 Provider Avg Days Completed to Submitted Avg Days Submitted to Effective Aetna 36 5 Alliance 92 17 Ambetter 54 29 BCBS 18 4 CIGNA 29 14 ETc... I have tried to unpivot the columns in a new table and I have tried creating 20 calculated columns to count the days then get the averages but I'm not able to create the desired chart. Thanks for all ideas and as an FYI, not all clinicians get credentialed by every insurance provider so there are a lot of blank date fields. Sample Data Here: docs.google.com/spreadsheets/d/1utsy80043RvkXQZ6hARR44E7TLUKGnVy/edit#gid=1505525352