Balancesheet Account Remapping

[Marco0984]

Hi all

I need some help and I was hoppeing that someone of you could help me. 

In my balancesheet I do have some accounts in the assets which have to move to the liabilieties if the amount is negativ. I also have liabilieties account which have to be mapped to the assets if they are postive.

My balance calculation is this dax formula:

Laufender Saldo =

CALCULATE(

    SUM('FaktenFibu'[Betrag in Hauswährung])*-1,

    FILTER(

        ALLSELECTED('DIMKalender'[Datum]),

        ISONORAFTER('DIMKalender'[Datum], MAX('DIMKalender'[Datum]), DESC)

    )

)

This is an example of my dimension table of the balances sheet account (called BSKontenplan). I already added the information of the new mapping.

That means: if amount on account 68400 is smaller than 0.00 then it has to go to account 68400_W and 0.00 on 68400

Any idea how so solf that?

Thank you very much for your help. I already wasted a day with google 🙂