Add SUMIFS column in PowerQuery Editor in PowerBI

[RDercks13]

Hello - 

After a few days of struggling with this tyring to use other recommended solutions, I have given up and decided to come here for help.  When looking at other solutions for this problem, I don't even seem to have the option to enter DAX formulas to create a column.  For instance:

Where as I see:

And when trying to use formulas such as SUMX, they are not even recognized.  Clearly it seems that I am doing something wrong or entering things wrong altogether, so I'm hoping some kind soul can help out this beginner.

[Ritaf1983 · Accepted solution]

Hi @RDercks13 
If you want to add a calculated column with Dax you need to do it from the "front side " >> table view 

your second image is from PQ, PQ's language is M, and he doesn't speak DAX.

More information about the differences is here : 
https://www.sqlbi.com/articles/comparing-dax-calculated-columns-with-power-query-computed-columns/

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly