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.

Seward12533's avatar
Seward12533
Icon for Solution Sage rankSolution Sage
8 years ago

DateCheck = [datefieldtable1]>CALCULATE(AVERAGE(Table4[datefield]),Table1)  You should have and may need a Calendar Table where they Key Date fields from 1,3 and 4 respectively link to the the key date in your date table. 

 

This should work, specifying the other table in the calculate will force the filter context from Table 1 to be enforced based on the relationships.  Don't know your data model well enough to know if the relationships you have defined will be sufficent.