Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 😉
User | Count |
---|---|
57 | |
22 | |
21 | |
19 | |
16 |
User | Count |
---|---|
87 | |
87 | |
52 | |
37 | |
23 |