Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Marco0984
Regular Visitor

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?

 

Marco0984_0-1700559141288.png

 

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

 

 

0 REPLIES 0

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.