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 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
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
Helpful resources
FabCon Global Hackathon
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Power BI Monthly Update - September 2025
Check out the September 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
