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...
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.
This is how the statement should look but it is telling me they aren't related, but they are.