Forum Discussion
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...
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.
Would something as simple as this work for you:
Your Column = IF(
[ufv_time_in] < MIN('vsl_vessel_visit_details'[cargo_cutoff]),
1,
0
)
Unfortunately this did not work for me, but another user posted a solution that did work, the use of the "RELATED" function was what this needed!