Forum Discussion

VictorR's avatar
VictorR
Frequent Visitor
8 years ago
Solved

How to create a custom column that compares dates from two different tables in one of the tables?

Hi,   I have 4x different tables loaded into PowerBI Desktop. Table1 has a Many To One relationship to Table2 which has a Many To One relationship to Table3 which has a One To One relationship with...
Need Help
  • praiselyabraham's avatar
    praiselyabraham
    8 years ago

    Hi ,

    Based on the scenario, this is what i did as a replicate of your scenario.

    Then created a column in table one as 

     

    Date Check Flag = IF([Date]> RELATED(Table4[Date]),1,0)

     

    Alternatively you can create two column in table as 

    Table4 Date = RELATED(Table4[Date])

    Check Flag = IF([Date]>[Table4 Date],1,0)

     

    This gives the required flag for you 

     

     

     

    Hope this solves your issue.

     

    Regards.

praiselyabraham's avatar
praiselyabraham
Icon for Resolver II rankResolver II
8 years ago

Hi ,

Based on the scenario, this is what i did as a replicate of your scenario.

Then created a column in table one as 

 

Date Check Flag = IF([Date]> RELATED(Table4[Date]),1,0)

 

Alternatively you can create two column in table as 

Table4 Date = RELATED(Table4[Date])

Check Flag = IF([Date]>[Table4 Date],1,0)

 

This gives the required flag for you 

 

 

 

Hope this solves your issue.

 

Regards.

VictorR's avatar
VictorR
Frequent Visitor
8 years ago

Thank you very much! It was the "RELATED" function that solved this and gave me the expected results I was looking for!