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
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
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
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
Proud to be a Super User!
Hi Danextian
See original data
LOCATION | SECTOR | JOB NAME | CURRENT MARGIN | Jul-18 | Aug-18 | Sep-18 | Oct-18 | Nov-18 | Dec-18 | Jan-19 | Feb-19 | Mar-19 | Apr-19 | May-19 | Jun-19 |
BRIS | Residential & Hotels | A | 4.0% | 707,517 | 890,369 | 1,051,250 | 1,280,451 | 1,365,493 | 638,234 | 519,239 | 200,593 | - | - | - | - |
GOLD | Health | B | 8.5% | - | 226,698 | 798,378 | 780,087 | 750,195 | 369,605 | 152,877 | - | - | - | - | - |
GOLD | Residential & Hotels | C | 6.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 | - |
BRIS | Aged Care | D | 6.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 |
BRIS | Residential & Hotels | E | 15.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 |
BRIS | Residential & Hotels | F | 6.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] | ||||||
LOCATION | SECTOR | JOB NAME | CURRENT MARGIN | MONTH | Turnover | Gross Profit |
BRIS | Residential & Hotels | A | 4.0% | Jul-18 | 707,517 | 28,103 |
BRIS | Residential & Hotels | A | 4.0% | Aug-18 | 890,369 | 35,365 |
BRIS | Residential & Hotels | A | 4.0% | Sep-18 | 1,051,250 | 41,756 |
BRIS | Residential & Hotels | A | 4.0% | Oct-18 | 1,280,451 | 50,859 |
BRIS | Residential & Hotels | A | 4.0% | Nov-18 | 1,365,493 | 54,237 |
BRIS | Residential & Hotels | A | 4.0% | Dec-18 | 638,234 | 25,351 |
How I wish to aggregate
OTHER WAYS TO CUT DATA | ||
Turnover | Gross Profit | |
BRIS | ||
GOLD | ||
OTHER WAYS TO CUT DATA | ||
Turnover | Gross Profit | |
Residential & Hotels | ||
Health | ||
Aged Care |
Quick measure issue
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
89 | |
84 | |
76 | |
64 |
User | Count |
---|---|
135 | |
112 | |
98 | |
98 | |
92 |