Friday, February 1, 2019

Power BI - Division by Zero Error encountered

https://community.powerbi.com/t5/Desktop/division-by-zero/td-p/48702


Create new Measure
syntax is IF(Condition, Then, Else)

=IF([QuantityKG] = 0,0,DIVIDE([NetValue],[QuantityKG])

No comments:

Post a Comment