Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello I´m using the following code to calculate de incremental production per year but I´m having a problem when calculating the incremental production in the last year, I got 0 because the LastPeriodProduction and the FirstPeriodProduction is the same, then: LastPeriodProduction-FirstPeriodProduction=0 ... When there is only one date in a ayer I need to substract the previous year last production from the actual production like this:
Year 3 A: 800 (Jan-03) - 750 (mar-02) = 50
TIME | WELL | WOPT | Incremental prodUction | ||
jan-01 | A | 100 | Year 1 A | 200 | |
feb-01 | A | 200 | Year 2 A | 250 | |
march-01 | A | 300 | Year 3 A | 50 | |
jan-02 | A | 500 | |||
feb-02 | A | 600 | Year 1 B | 200 | |
march-02 | A | 750 | Year 2 B | 150 | |
jan-03 | A | 800 | Year 3 B | 50 | |
jan-01 | B | 200 | |||
feb-01 | B | 300 | |||
march-01 | B | 400 | |||
jan-02 | B | 800 | |||
feb-02 | B | 900 | |||
march-02 | B | 950 | |||
jan-03 | B | 1000 |
This is the code I am using:
Hello @Anonymous can you help me with this?
Yes I can do it in power query but I don´t know how
Hi @OscarSuarez10,
I'm very sorry, I haven't been writing DAX for long time and I'm not good at it anymore.
But if you have another PowerQuery question in the future, let me know 😉
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
33 | |
18 | |
18 |