Forum Discussion
Solved
Divide two columns DAX
Hello, I need to calculate percentage and this is the DAX formula which isnt working: PercentDifference= DIVIDE('Query1'[SALES]*100; 'Query1'[PLANNED_SALES] ) Divide function works if I p...
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,
thank you for being there.
What happens if you try a different operator.
PERCENT_DIFFERENCE_test = Query1[SALES] + Query1[PLANNED_SALE]
with plus operator, the result is good.
or even this
PERCENT_DIFFERENCE_test2 = Query1[SALES]
with assigning it 'copies' just fine
or
PERCENT_DIFFERENCE_test4 = Query1[PLANNED_SALE]
finally
PERCENT_DIFFERENCE_test = Query1[SALES] / Query1[PLANNED_SALE]
BUT, with / operator I get infinity in every row in a column
When I put * operator, the column is empty
what could it be?
Sorry to keep suggesting tests but how about this one
PERCENT_DIFFERENCE_test5 = IFERROR( Query1[SALES] / Query1[PLANNED_SALE] , -1)