Forum Discussion
Add SUMIFS column in PowerQuery Editor in PowerBI
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.
Hi RDercks13
If you want to add a calculated column with Dax you need to do it from the "front side " >> table viewyour 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
1 Reply
Hi RDercks13
If you want to add a calculated column with Dax you need to do it from the "front side " >> table viewyour 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