Forum Discussion
Helper IIIIFS STATEMENT IN DIRECT QUERY
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 , 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
3 Replies
- amitchandak
Super User
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
Amjad1002Hi Amit,
When I try to add custom column is showing me this error into direct query.
- Amjad1002
And even I try to switch into table import mode. It is now working and showing me this eror.