Gross Profit - From Turnover and Gross Margin

[JayGriff]

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

[danextian]

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

[JayGriff]

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