Relationship with two Date Column with Date Table Column

Hi Anonymous 

You need to add an inactive relationship to join on Closed incident. Then create a measure 

CALCULATE(SUM() , UERELATIONSHIP())

If you can give more details or share a Sample, would be better explained

Hi Anonymous 

In a table, you can only select one date column to be active with the date column in the date table, and when you select Received Incident Date Column and Date Table Date Column to associate, the other date column is inactive with the date column in the date table, and you can choose to use USERELATIONSHIP() function to active the relationship between other two columns.You can refer to the following link.

Using USERELATIONSHIP in DAX - SQLBI

Active vs inactive relationship guidance - Power BI | Microsoft Learn

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.