Forum Discussion
Solved
Need some assistance with DAX
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...
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")
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
Resolver III
Resolver IIIOK, 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")
- 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?