Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
106 | |
88 | |
82 | |
76 | |
73 |
User | Count |
---|---|
112 | |
103 | |
96 | |
74 | |
67 |