Need some assistance with DAX

[Casey_ONeal]

Hi, I am somewhat new to Power BI and I could use some assistance with a calculation I need to do. Basically, I have two related tables let's call them Table 1 and Table 2. I need to calculate whether or not a date is less than or equal to another date if they are then return good if not then return overdue. Date1 <= Date2, Good, Overdue something along these lines.

[Michiel]

 You'll need to provide some more details here. Your two tables are related, you say? Meaning there's a relationship between the two in the Power BI model? If so, on what fields? And if not, how would Power BI know which two dates to compare? There can be many in each table.

[Casey_ONeal]

Yes, there is a 1:1 relationship in the Power BI model based on a field containing component names/codes which are unique identifiers.

[Michiel · Accepted solution]

OK, and the date fields are in one table each?

In this case, you could e.g. create a calculated column in Table1 with:
= IF(Table1[Date1] <= RELATED(Table2[Date2]), "Good", "Overdue")

[Casey_ONeal]

Michiel, Thank you for the assistance here. Follow up question for anyone. Can you do the same thing with tables that have an indirect relationship?