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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi matka123499 ,

You can use below query to check for the black values..

 

[Column Name] = IF ( 'YourTable'[Total Area] <> 0,

'YourTable'[Rental Value (ERV)] / 'YourTable'[Total Area],

BLANK () )

 

If you like this solution please upvote and consider marking it as solution accepted

 

Thanks!

  • matka123499's avatar
    matka123499
    Frequent Visitor
    2 years ago

    I used bellow but get an error Token literal expected.

    Column Name] =  IF ( 'Merged Data'[Total Area] <> 0,

    'Merged Data'[Rental Value (ERV)] / 'Merged Data'[Total Area],

    BLANK () )