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.
Hi,
I tried to look at previous topics, but the ones I could find are not really helping me with my problem.
I've column A which tells me if it's a sales or purchase line and then column B gives me the value (always positive - unless return etc.). I made a formula that if column A says sales it should convert the formula against *-1. So my purchases up the stock and sales lower it (thats why negative value). However in my table the subtotal counts the negative and positive, both as a positive:
Formula I use to convert the value is:
Solved! Go to Solution.
Hi DevonVanDam,
You could refer to my sample to see whether it work or not.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
107 | |
94 | |
77 | |
63 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |