Forum Discussion
Helper VRow wise calculation in percentage
Dear Community.
Good Day.
I have posted this before, unfortunately i didn't get the answers.
Requesting all to help me out.
I have one P&L report. in this i have received only Plan and Actual values for category for multuple divisions.
I have attached the Pbix for your reference.
https://toyotsu.box.com/s/mboowbzdtokv925yklhig6t8dd74uli5
I got DAX for calucating the Variance and Achievement columns.
I requesting help from you guys to calculate Gross Profit Rate (Gross Profit/Sales) for perticular division in row wise and place the value in perticular column in vistualization like as shown above table.
Its realy great thanks to all in advance.
17 Replies
- Daniel29195
Community Champion
Hello Nadeem,
can you show an example of the desired result , ( in excel per example ) .
cause im not sure i quite understand the problem with calculating (Gross Profit/Sales) since you already calculated the Variance and Achievement column
best regards
NadeemAhamedDear Daniel29195 Sir,
Good Day.
Thank you for your valuable time to read and reply my post.
As i understood your question u want to see the example how i am calculating the difference in excel sheet, Is It right?
- Daniel29195
nevermind, my bad, didnt focus on the image you have attached.
i got what you want 😅
give me some time and i will send you the solution .
best regards
