Forum Discussion
Divide two columns DAX
Hello all,
Thank you for you efforts. I finally found the solution.
What I needed to do was:
- create three measures:
Sale = SUM(Query1[SALES])*100
PlannedSale = SUM(Query1[PLANNED_SALES])
Percentage= DIVIDE([Sale];[PlannedSale])
Only this way worked for me and it is cool. Thank you guys
Hello all,
Thank you for you efforts. I finally found the solution.
What I needed to do was:
- create three measures:
Sale = SUM(Query1[SALES])*100
PlannedSale = SUM(Query1[PLANNED_SALES])
Percentage= DIVIDE([Sale];[PlannedSale])
Only this way worked for me and it is cool. Thank you guys
This syntax did not work for me: Percentage= DIVIDE([Sale];[PlannedSale])
Instead of an " ; " I had to use a comma. I should have read the example....🤣 But for those going quickly with copy and paste, RTFM! I had a headache for about 10 minutes before I caught this.