Forum Discussion

martaredondo's avatar
martaredondo
Helper II
6 years ago

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...
Need Help
v-xuding-msft's avatar
v-xuding-msft
Community Support
6 years ago

Hi martaredondo ,

 

Please share some sample data and your expected output. Then we will understand more clearly about your requirement.

 

With direct query mode, if we create a calculated column, the mode will change to mixed mode.  It means the original data is still with DQ mode. And the new column is with import mode. For this part, you could reference the document to learn more.

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about#modeling-limitations