I’m working on a P&L overview, basesdon working with a template as per the video Financial Reporting with Power BI. Unfortunatelly, I’m facing 2 problems now and I really don’t know how to fix them.
The first problem is with the sheet called P&L Years. I have calculated this year and last year values, and the difference between TY and LY. But for “Omzet” it will not give me the correct difference in the table. Whileif i calculate it manually, so with a measure “Omzetverschil” for Omzet - Omzet LY, it is correct. All other differcences seems to be okay so I don’t know what is wrong with it?
The 2nd problem is on sheet called P&L Percentages. I want to calculate all amounts as a percentage of “Omzet”. So i have made calculations for all subtotals and they work fine, but all rows in between should also be filled in. If not used in a template table but in a normal table, the actuals% formula is working as you can see in the table on the right. But I can’t figure out why this is not working in the table with the template? I used the same formula as i did with the amounts in euro’s (see on page Winst and Verliesrekening) and there it is working correctly…
It would be great if somebody can help me, many thanks!
Versie met Template.pbix (1.7 MB)