Forum Discussion
IF/SWITCH alternative with DirectQuery
Hi everybody, I'm facing a problem regarding the IF/SWITCH function because i'm using DirectQuery. I created a measure and tried using IF/SWITCH but it doesn't allow me to do any comparison w...
Hi martaredondo
If your tables are related, you can use RELATED() function to do it. Something like this:
column = IF(RELATED(table1[column1]) = "A", table2[Column2], table2[column3])