Solved: How to calculate a turnover with the first price f... - Page 2

jopezzo · ‎06-07-2019

Hi! I am trying to calculate a turnover not based on the price that appears on each row of my fact table, but based on the first price found.

Example:

Month	Quantity	Price	Turnover
1	145	1,187	172,115
2	149	1,187	176,863
3	182	1,187	216,034
4	155	1,187	183,985
5	111	1,187	131,757
6	128	1,187	151,936
7	105	1,187	124,635
8	142	1,187	168,554
9	118	1,163	137,234
10	162	1,163	188,406
11	175	1,163	203,525
12	155	1,163	180,265
			2,035,309

For the turnover, I would have something like:

Turnover =

SUMX(fact_Volumes,fact_Volumes[Price]*fact_Volumes[Quantity])

What I would like is a measure to calculate the turnover with the actual quantity and the first price appearing in the table. In this example I would have all the quantities multiplied by the price 1,187.

Any idea?

HotChilli · ‎06-14-2019

Thanks for the data.

I changed the formula to take different Material into account.

Create a column

EarlyPrice Revenue = VAR _CurrMaterial = FactPrices[Material] 
  RETURN
   FactPrices[Quantity] * CALCULATE(SUM(FactPrices[Price]) , 
                                    FILTER(FactPrices, 
                                            FactPrices[Material] = _CurrMaterial && 
                                            FactPrices[DateKey] = MIN(FactPrices[DateKey])
                                            )
   )

View solution in original post

How to calculate a turnover with the first price found in a table?

Helpful resources

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024