Power Query divide

[matka123499]

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 use DIVIDE function it shows that it´s not recognized.

The two columns I need are 

=[#"Rental Value (ERV)"]/[Total Area]

Can you please help me so everything divided by 0 returns as blank without errors?

Thank you

[v-xinruzhu-msft · Accepted solution]

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]

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]

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 () )

[Vijay_A_Verma]

Use below. You can use anything else also in place of null

= try [#"Rental Value (ERV)"]/[Total Area] otherwise null

[matka123499]

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

[Anonymous]

Hi @matka123499 ,

try this one

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