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.
I'm working with a combined table - Current ERP data + Historical data (.xlsx) merged by query.
I used the following formula to create a custom column for weight (also to get rid of the "-")
My current data turns out fine 2019, 2020 but within the historical data the weight values of identical rows end up summarized.
Using SUMX leaves me with the following error message:
Any thoughts on how to solve this?
Hi @fbron ,
Try creating a measure rather than a column.
If this helps please give Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
Hi @fbron ,
SUMX is an aggregator calculation the first parameter is a table and the second the calculation you need. So your measure needs to be something similar to:
SUMX(Table;SUM(Table[Weight))
If you are just trying to replaced the negative to positives have you tried the ABS formula?
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsI did manage to get this done with a measure, problem is that eventually I'm in need of a running total for the weight column.
Something like this:
As far as I know I'm in need of a column to get to that running total, tried it with the (working) measure but couldnt get it done.
Calculating running total in a measure is slightly different to a column.
Please check this post: https://community.powerbi.com/t5/Desktop/Create-Running-Total-On-A-Calculated-Measure/td-p/164202
Paul Zheng
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |