Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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?
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 20 | |
| 11 | |
| 9 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 31 | |
| 29 | |
| 21 | |
| 12 | |
| 12 |