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
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Yrstruly2021 ,

 

You can try formula like below:

DebtorMovements = 
CALCULATE(
    -SUMX(
        FILTER(
            'ZTBR',
            'ZTBR'[Roll_Up_Function] = "Debtor Movements"
        ),
        'ZTBR'[Amount in USD]
    ),
    'ZTBR'[Roll_Up_Function] = "Debtor Movements"
) + 4801

 

Best Regards,
Adamk Kong

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.