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]...
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)