Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

If then Else Statement

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

 

 

1 Reply

  • az38's avatar
    az38
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hi Anonymous 

    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)