Forum Discussion
nickuhlenhuth
7 years agoNew Member
undefined
The DIVIDE function doesn't work in PowerBI. It is multiplying results by 3.
Resolved now.
The issue was that I was creating a Column using DIVIDE between two aggregated columns that had 3 rows.
Once I changed to use DIVIDE within a Measure, it worked as expected.
2 Replies
- d_gosbellSuper User
Are you saying that DIVIDE( exp1, exp2 ) produces a different result to exp1 / exp2 ? This does not sound right. Can you post a screenshot with a table showing the denominator, numerator and the result of the divide function?
- nickuhlenhuthNew Member
Resolved now.
The issue was that I was creating a Column using DIVIDE between two aggregated columns that had 3 rows.
Once I changed to use DIVIDE within a Measure, it worked as expected.