Forum Discussion
Balancesheet Account Remapping
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 🙂
No RepliesBe the first to reply