Convert calculated column expression into custom column syntax to do the same operation.

[NewbiePowerBye]

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,

[Greg_Deckler · Accepted 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