Forum Discussion

VinitGohil1976's avatar
VinitGohil1976
Frequent Visitor
1 year ago
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 ...
Interesting Links
Need Help
Tips and Tricks
Tutorial Requests
  • johnt75's avatar
    johnt75
    1 year ago

    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
Deku's avatar
Deku
Super User
1 year ago

Max( max( Agreement[Agreement Activated Date]), max(Policy[Policy Date]))

  • VinitGohil1976's avatar
    VinitGohil1976
    Frequent Visitor
    1 year ago

    That also causes the same issue. I am basically trying to define this Sql logic in Power Bi

     

    date_add(IF(pol.PolicyStartDate > agr.AgreementActivatedDate, pol.PolicyStartDate, agr.AgreementActivatedDate), 60) as CancellationDueDate
     
    I tried with IF clauses and SWITCH statements also but i think the issue is more with the model than it is with the dates. If there are any further suggestions, i am willing to try any... thanks