SUMMARIZE problem

Question

I have a problem when creating summarize table from main data table using SUMMARIZE function. The original data contains £ by duration in months e.g

Months	£
1	34643
1	3461
2	12446
2	378
3	3451
3	78358
6	24577

However, summation table is summing both tenor and £ amount to give:

1	232
2	2455
3	2352
12	2351
45	1412
445	141

The formula is

SUMMARIZE(table, table[Tenor], "summary £ value",SUM(table[£])). The problem may be because Tenor column is in whole number format and not text? however, it is from an original data source and returns an error when I try change column into text rather than whole number.

valtterin · Answer

Hi,I am not sure I follow but if you want to summarize your data based on a month your dax will work fine:

However if you have additional dimension column "Tenor" you can use this dax:

Table 7 = SUMMARIZECOLUMNS('Table (18)'[Months],'Table (18)'[Tenor],"sum",SUM('Table (18)'[£]))

&nbsp;
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/