Forum Discussion

Yrstruly2021's avatar
Yrstruly2021
Helper V
2 years ago

Formula To Excel

Pease give DAX for =-SUMIF(Details!B:B;'Cash Flow'!G34;Details!G:G)+4801. I have  DebtorMovements = CALCULATE(     -SUM('ZTBR'[Amount in USD]),     'ZTBR'[Roll_Up_Function] IN {"Debtor Movements...
DAX
Excel
formulas
Yrstruly2021's avatar
Yrstruly2021
Helper V
2 years ago

It is not suppose to list values for every row.

 

govindarajan_d's avatar
govindarajan_d
Super User
2 years ago

Try this:

 

DebtorMovements=
IF (
    SELECTEDVALUE('ZTBR'[Roll_Up_Function])="Debtor Movements",
    CALCULATE (-SUM ('ZTBR'[Amount in USD]),'ZTBR'[Roll_Up_Function]="Debtor Movements")+4801,
    BLANK()
)