Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
JayGriff
Regular Visitor

Gross Profit - From Turnover and Gross Margin

I have a series of projects over date ranges with turnover per month and a single current margin as at now.  

 

I'm looking to calculate the gross profit per month based upon the current margin figure * turnover and be able to look at this per project and per month and in total, split by geography,  sector etc.

 

See below for an idea on the underlying data

JayGriff_0-1662518480585.png

 

Any help on the right measure for this would be greatly appreciated.

*Note I have unpivoted columns in data file for turnover

**When i try quick measure and multiplication it takes the count of current margin not each unique instance

2 REPLIES 2
danextian
Super User
Super User

Hi @JayGriff ,

 

If you want a visual to look just like how it is in your screenshot, it will be quite tasky and will require advanced skills. For other things, can you please post a sample data that we can easily manipulate (not an image) and formula  for your measures if you were to do it in Excel? Also, what do you mean by this?

**When i try quick measure and multiplication it takes the count of current margin not each unique instance










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

Hi Danextian

 

See original data

LOCATIONSECTORJOB NAMECURRENT MARGINJul-18Aug-18Sep-18Oct-18Nov-18Dec-18Jan-19Feb-19Mar-19Apr-19May-19Jun-19
BRISResidential & HotelsA4.0%  707,517      890,369             1,051,250             1,280,451             1,365,493                638,234                519,239                200,593                        -                          -                          -                          -  
GOLDHealthB8.5%          -        226,698                798,378                780,087                750,195                369,605                152,877                        -                          -                          -                          -                          -  
GOLDResidential & HotelsC6.0%######   1,116,066             1,525,504             1,916,448             2,031,790             1,853,773             1,238,399             1,381,410             1,040,252                587,884                  73,081                        -  
BRISAged CareD6.8%  520,202      840,694             1,030,562             2,072,397             2,053,704             2,535,472             2,392,259             1,575,285                820,829                859,666             2,121,711                325,000
BRISResidential & HotelsE15.0%  697,836   1,773,007             3,912,913             2,697,404             2,773,429             2,163,959             3,292,448             6,201,440             6,541,649             7,500,000             7,774,927             6,164,529
BRISResidential & HotelsF6.5%    24,711               -                    52,450                        -                    23,500                393,614                712,027                811,012             1,031,606             1,319,800             1,031,462             1,289,714

 

Reformatted using transform data

 

REFORMATTED - VIA TRANSFORM DATA      
      

WHAT I'M AFTER

[turnover * current margin]

LOCATIONSECTORJOB NAMECURRENT MARGINMONTHTurnoverGross Profit
BRISResidential & HotelsA4.0%Jul-18      707,517                  28,103
BRISResidential & HotelsA4.0%Aug-18      890,369                  35,365
BRISResidential & HotelsA4.0%Sep-18   1,051,250                  41,756
BRISResidential & HotelsA4.0%Oct-18   1,280,451                  50,859
BRISResidential & HotelsA4.0%Nov-18   1,365,493                  54,237
BRISResidential & HotelsA4.0%Dec-18      638,234                  25,351

 

How I wish to aggregate

 

OTHER WAYS TO CUT DATA 
 TurnoverGross Profit
BRIS  
GOLD  
   
OTHER WAYS TO CUT DATA 
 TurnoverGross Profit
Residential & Hotels  
Health  
Aged Care  

 

Quick measure issue

JayGriff_0-1662524469719.png

 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.