Forum Discussion
Solved
DAX to M code (dividing within same column)
Hi. I have a following DAX code to calculate percentage of a component (by dividing quantity of component with total). Table fileds are (ID, quantity, factor and component). I use my DAX code as meas...
davidz106 , In power query you have duplicate table, Filter it and the use group by- https://docs.microsoft.com/en-us/power-query/group-by
In that you ill get the total column
Merge the tables and you the line value and sub total
Divide into a new column
merge : https://radacad.com/append-vs-merge-in-power-bi-and-power-query
davidz106 , In power query you have duplicate table, Filter it and the use group by- https://docs.microsoft.com/en-us/power-query/group-by
In that you ill get the total column
Merge the tables and you the line value and sub total
Divide into a new column
merge : https://radacad.com/append-vs-merge-in-power-bi-and-power-query