Forum Discussion
Solved
Comparing Dates between two different tables
I am trying to create a new custom measure that will compare two dates from two different tables. This is how the model has been defined I need to compare the Agreement[Agreement Activated ...
You could create a calculated column in the agreement snapshot fact table like
Cancellation Due Date = MAX ( RELATED ( Agreement[AgreementActivatedDate] ), RELATED ( Policy[Policy Date] ) ) + 60
You could create a calculated column in the agreement snapshot fact table like
Cancellation Due Date =
MAX (
RELATED ( Agreement[AgreementActivatedDate] ),
RELATED ( Policy[Policy Date] )
) + 60