Forum Discussion
SUM Issue
Dear Community, I have a simple issue using "sum"... I have a table with multiple lines, linked an id/category but when I try to have the total cost per category, here which is supposed to be ...
Hi,
I believe this should work, based on the table you posted.
SUMX(
'CL',
Jan + Feb + Mar + Apr +...
)
Alternatively, I will advise you to unpivot the month columns and have all Months in a single column and values in another column. That way, SUM(Values) will just work.
htanks, but still not working :
CL SUM2 = SUMX(
'CL',
CL[Jan] + CL[Feb] + CL[Mar] + CL[Apr] + CL[May]+ CL[Jun]+ CL[Jul]+ CL[Aug]+ CL[Sep]+ CL[Oct]+ CL[Nov]+ CL[Dec]
)
I still have the global total.
Kasiop