Hi all!
This must be an easy question to solve, but I'm not clear today and I'm a bit stuck on this.
I have some rows with the consumption for a lot of different supplies and the price I had paid for the invoice in € over years.
What I want is to define a formula which calculates the unity price I'm paying to make a comparison between years and months. For instance the price of the KWh if I have selected electricity in my slicer.
Data is structured in this way (of course I have dim tables for center, dates and type of cons):
| Center | Date | Consumption | Invoice total paid | Type of cons. |
| A | 01/07/2023 | 14500 | 17800€ | Electricity |
| A | 01/07/2022 | 15700 | 19000€ | Electricity |
| A | 01/07/2023 | 1400 | 5600€ | Water |
| A | 01/08/2023 | 1450 | 5738€ | Water |
| B | 01/07/2023 | 17800 | 23000€ | Electricity |
| B | 01/08/2022 | 18560 | 18560€ | Electricity |
I think the calculus must be done with sumx and divide (price/consumption), selectedvalue for type of cons. but I'm struggling with it.
Thank you in advance.
