Forum Discussion
If Statement to Compare Two Values From Different Tables
All, I am making a table in PBI and have all I need except for one missing piece. The highlighted event represents a problem that occurs occasionally. I have the Last Crew field whi...
Rudy_D
Resolver I
Resolver IHi Collin,
Are "Last Crew" and "Who completed" fields from the same table ?
You can simply create une new column with this formula :
New Column = IF(ISBLANK('Table'[Last crew]), 'Table'[Who completed], 'Table'[Last crew])
Regards,
Rudy
They are in two separate tables. The last crew was unitname from the 'Crew Actions' table and Who Completed is from the 'Jobs' table. I am using the Last function on the dropdown to get the last crew, so I am not necessarily sure how to write that in DAX. That is where my confusion is coming from.
I renamed 'unitname' to 'last crew' so end users don't get confused.
This is how the statement should look but it is telling me they aren't related, but they are.
- Rudy_D
Do you have a date field in the 'Jobs' table ?
If so, you could make both tables related using a calendar table.