March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hello I need to calculate the difference between production and Investment but only for the year In which the production starts, that means that Production > 0, using DAX like in the following table, can you help me?
Product | Year | Production | Production - Investment | Investment |
A | 1 | 100 | -600 | 700 |
A | 2 | 50 | 50 | |
A | 3 | 20 | 20 | |
B | 1 | 0 | 0 | |
B | 2 | 500 | -200 | |
B | 3 | 400 | 400 | |
C | 1 | 0 | 0 | |
C | 2 | 100 | -600 | |
C | 2 | 789 | 798 |
Should be something along the lines of:
Investment = IF([Production]<=0,BLANK(),[Production] - [Production Investment])
Hello, Thank You for your help, the thing is that I need to subtract the investment only in the year when the production starts (production > 0) , how can I do that?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
27 | |
17 | |
16 | |
12 | |
11 |
User | Count |
---|---|
38 | |
29 | |
22 | |
20 | |
18 |