Forum Discussion

NadeemAhamed's avatar
NadeemAhamed
Icon for Helper V rankHelper V
2 years ago

Row 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 Ac...
General Comment
Need Help
Show and Tell
Tips and Tricks
NadeemAhamed's avatar
NadeemAhamed
Icon for Helper V rankHelper V
2 years ago

Daniel29195 

 

Thank your valuable time to response.

 

Yes sir, its realy great you are using only two column such as Plan and Actual column.

But my query is from the sales dept i will get only this table data.

 

In Power BI we have to calculate "Gross Profit Rate" for Plan and Actual columns by using "Gross Profit/Sales"

 

 

We have to place Gross Profit Rate data values after the Gross Profit row in table vistualization.

 

 

 

Daniel29195's avatar
Daniel29195
Icon for Community Champion rankCommunity Champion
2 years ago

Hello NadeemAhamed 

 

kindly check now : filename : Calucating Variance, Achievement from Plan and Actual1

https://drive.google.com/file/d/1Fh9SEHvOatffQFsUoCBmVciNK7NCk9jw/view?usp=sharing

 

 

this is the data used : 

 

this is the output : 

 

 

 

 

 

 

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅!
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠