Forum Discussion

Hijau's avatar
Hijau
Frequent Visitor
8 years ago
Solved

Matrix into P&L Statement

Hi community,   Currently trying to turn a matrix into a P&L statement. Have been lurking here for a while so I've seen a lot of recommended video's and posts but I'm still struggling with the ...
  • Hijau's avatar
    Hijau
    8 years ago

    Hi Dale,

     

    Thanks for your reply. 

     

    I figured it out: 

     Now I'm trying to subtract the total of 'Uitgaven' from the total of 'Omzet'! 

     

    Cheers,

     

    Dexter

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Dexter,

 

I have to consult the idea P&L. What's relationship between Matrix and P&L?

Just see from your image, you put the wrong hierarchies in the Row of the Matrix. The parent level has itself as the child level. What's your data structure? What's the expected result? Can you share a dummy sample?

Matrix

 

Best Regards,

Dale

Hijau's avatar
Hijau
Frequent Visitor
8 years ago

Hi Dale,

 

Thanks for your reply. 

 

I figured it out: 

 Now I'm trying to subtract the total of 'Uitgaven' from the total of 'Omzet'! 

 

Cheers,

 

Dexter

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Hijau,

    I am a beginner making P&L statement in PBI.

    Please can you share your PBIX file with me , if you don't mind?

     

    Thanks,

    spanda