fbronFrequent Visitor6 years agoSUM / SUMX Column 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 cu...Show More
Pragati11Super User6 years agoHi fbron , Try creating a measure rather than a column. If this helps please give Kudos and mark it as a Solution! 🙂 Thanks,Pragati
Related contentSumXSUMX & FILTER or SUM & CALCULATE: Best practice for summing subset of columnsCALCULATE SUM vs. SUMX RELATEDTABLESUMXSUMX works, but not CALCULATE SUM
