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...
martaredondo , what is your if statement. If it across two tables then you can not do like
if(Table[A]=Table2[A],,)
You can try like if(Max(Table[A])=max(Table2[A]),,)
You have to make sure you force some row context using summarize or values.
Refer how common row context use for date diff