Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello Everyone,
My name is Leonardo and I have this table :
[IMG]http://i66.tinypic.com/29qfl88.png[/IMG]
The table shows the volume in "M3" for each SKU produced, as well as the Volume of "Lubricacion Consumo (M3)" and "Consumo Lavadora (M3)", which are the same for each "LINEA". The general consumption of water on the "Consumo M3" day is also shown. What I want to calculate: "Otros consumos (m3)" = "Consumo M3" - "Consumo Lubricacion (m3)" - "Consumo Lavadora (m3)"; for each day. for example: For 03/01/2018 would have Other consumptions (m3) = 686 - (41 + 21 + 40 + 0) - (135 + 100 + 0 + 154).
Likewise I want to calculate the WUR (Water Usage Ratio) = ((Sum of "M3") + (Sum "Consumo M3")) / (Sum of "M3"), for each day. For example: For 03/01/2018 I would have WUR= ((28 + 107 + 68 + ....) + 686) / (28 + 107 + 68 + ..) Please help me, I've broken my head trying to calculate it with distinct but it still does not work out.
My entire thanks. Leonardo LIMA PERU
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
12 | |
11 | |
8 | |
6 |