Forum Discussion
Anonymous
6 years agoNot applicable
P&L Custom Total Calculation/ Formating
Would like to ask for advise on the P&L - Budget vs Actual I need for our dashboard. I need to show the bottom totals as "Total Cost of Goods Sold" (Income - Cost of Good Sold) and the total % of...
FrankAT
6 years agoCommunity Champion
Hi Anonymous ,
take a look at Matt Allington's blog post at https://exceleratorbi.com.au/build-a-pl-with-power-bi/
Regards FrankAT
- Anonymous6 years agoNot applicable
FrankAT - Thank you for the link! i was able to do the Plan and Actual Column. the Variance column and % Variance is still giving me a hard time. not sure if it is because it is from 2 different tables.