IFS STATEMENT IN DIRECT QUERY

[Amjad1002]

Hello folks,

I am trying to use ifs statement into my direct qurey table. I am trying to add condition or customer column but I am getting an error.  Are we not able to add column if there is a direct query ?

Thanks

[Amjad1002]

And even I try to switch into  table import mode. It is now working and showing me this eror.

[amitchandak · Accepted solution]

@Amjad1002 , You can add simple columns using if. But if try to cross-row operation it might not work

explained here

Power BI Decoding Direct Query: https://www.youtube.com/playlist?list=PLPaNVDMhUXGbKatyDdOhGbTL3xW2Xy6pA

[Amjad1002]

Hi Amit,

When I try to add custom column is showing me this error into direct query.