Forum Discussion

fq98's avatar
fq98
New Member
3 years ago

SUMMARIZE problem

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 ...
ValtteriN's avatar
ValtteriN
Icon for Community Champion rankCommunity Champion
3 years ago

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)'[£]))

 

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/