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!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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?
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.