This formula of excel in power bi, how would it be?

[Anonymous]

Hello, I would greatly appreciate your help.
I have a doubt, this formula of excel? How could I apply in Pober Bi in Power Query Editor?

that's how it looks in excel

I need that formula here.

[v-diye-msft · Accepted solution]

Hi @Anonymous 

I didn't find the [NCN] column in your power query, but I believe the formula is easy to achieve in Dax, you can refer to the function: 

IF: https://docs.microsoft.com/en-us/dax/if-function-dax 

SUM: https://docs.microsoft.com/en-us/dax/sum-function-dax 

Below sample for your reference:

Measure 2 = var a = SUM(Table2[A])+SUM(Table2[B])
Return
IF(a=0,0,1)