Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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 ...
Need Help
FataiSanni's avatar
FataiSanni
Icon for Advocate IV rankAdvocate IV
3 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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