If Statement to Compare Two Values From Different Tables

Question

All,&nbsp;&nbsp;I am making a table in PBI and have all I need except for one missing piece.&nbsp;The highlighted event represents a problem that occurs occasionally.&nbsp;&nbsp;I have the Last Crew field which simply is this the last unitname frim the crew action table:&nbsp;&nbsp;If that field is blank though, I want to take the Who Completed field listed right beside it.&nbsp;&nbsp;Does anyone know a dax formula (I'm sure it is some sort of IF statement) to combine those two into one column? I am unsure how the Last option in field wells work, so any insight would be amazing.&nbsp;Thanks!&nbsp;&nbsp;If I can provide any more insight, please let me know.&nbsp;

anonymous · Answer

Bump

rudy_d · Answer

Hi Collin,&nbsp;Are "Last Crew" and "Who completed" fields from the same table ?&nbsp;You can simply create une new column with this formula :&nbsp;New Column = IF(ISBLANK('Table'[Last crew]), 'Table'[Who completed], 'Table'[Last crew])&nbsp;Regards,&nbsp;Rudy

anonymous · Answer

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.

anonymous · Answer

I renamed 'unitname' to 'last crew' so end users don't get confused.

anonymous · Answer

They are joined in the model view on event_idx if that provides any additional insight

Forum Discussion

If Statement to Compare Two Values From Different Tables

8 Replies

Related content

Compare different tables

Comparing values between different tables

Compare two columns in different tables

OR Statement ?

Compare 2 rows and highlight differences