Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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
And even I try to switch into table import mode. It is now working and showing me this eror.
@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
Hi Amit,
When I try to add custom column is showing me this error into direct query.
User | Count |
---|---|
84 | |
72 | |
71 | |
68 | |
55 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |