Forum Discussion

matka123499's avatar
matka123499
Frequent Visitor
2 years ago
Solved

Power Query divide

Hi,   I am trying to divide 2 columns in power query editor by adding a new column but when using simple / sign function I will get infinity, n/a etc return when 0 is included and when trying to us...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi matka123499 

    Try the following code.

    if [Total Area]<>0 then [#"Rental Value (ERV)"]/[Total Area] else null

    Output

     

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

matka123499's avatar
matka123499
Frequent Visitor
2 years ago

I tried this but still getting #Num! where anz of the divided columns is 0

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi matka123499 ,

 

try this one

Division Result = IFERROR(DIVIDE('YourTable'[Rental Value (ERV)], 'YourTable'[Total Area]), BLANK())