If then Else Statement

[rekhasagar04]

Hi,

I am in the process of converting Business Objects reports to Power BI.

This is the formula for Objects in BO.

=If(IsNull([Invoicenumber]);[Amountbase]-[Reconciled];0)

=If([Itemsumbase]-[Amountbase] Where ([Itemsumbase]+0>0)<0;0; [Itemsumbase]-[Amountbase] Where ([Itemsumbase]+0>0))

Can you please let me know how to create DAX on PBI? 

Thanks,

RS

[az38]

Hi @rekhasagar04 

first statement looks easy

If(ISBLANK([Invoicenumber]);[Amountbase]-[Reconciled];0)

not sure I understand second correct but it should be similar here

=
var _ifStatement = CALCULATE(SUMX(Table; [Itemsumbase]-[Amountbase]); [Itemsumbase]>0)
RETURN
If(_ifStatement<0; 0; _ifStatement)