Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have the following calculated column: X= CALCULATE(SUM(Query2Test[Asserts]),ALLEXCEPT(Query2Test,Query2Test[RunID])).
Still this column I can't see it in the query editor, so my question is how can convert the above expression and use it with the Custom Column to re-create it inside query editor. Is there any way to be convert the syntax to do the same thing but inside query editor -> Custom Column?
Thanks,
Solved! Go to Solution.
Maybe, looks like because of the ALLEXCEPT you would need to do a "group by" in your query somehow but I can't really tell you anything more without sample data and expected output.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Maybe, looks like because of the ALLEXCEPT you would need to do a "group by" in your query somehow but I can't really tell you anything more without sample data and expected output.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
User | Count |
---|---|
93 | |
85 | |
78 | |
68 | |
62 |
User | Count |
---|---|
113 | |
99 | |
96 | |
64 | |
58 |