Help with dates and totals

[TimK]

I am having great problems!

I have some sample data:

Product	01/01/2023	01/02/2023	01/03/2023	01/04/2023	01/05/2023	01/06/2023	01/07/2023	01/08/2023	01/09/2023	01/10/2023	01/11/2023	01/12/2023	01/01/2024	01/02/2024
A	12	55	22	33	22		33			22
B	11	59		33	33	21	2	22
A		22	23	35		2	11	3
A							22		24	89	21	1
A		22	36		9	2	2	3	3		3	3	3	3
B		58	2	2	8	8	5

Basically I am after a table that will then give me for each Product, the totals per month such as this:

Product	01/01/2023	01/02/2023	01/03/2023	01/04/2023	01/05/2023	01/06/2023	01/07/2023	01/08/2023	01/09/2023	01/10/2023	01/11/2023	01/12/2023	01/01/2024	01/02/2024
A	12	99	81	68	31	4	68	6	27	111	24	4	3	3
B	11	117	2	35	41	29	7	22	0	0	0	0	0	0

And then finally, a table that gives me the maximum value, and the corresponding date:

Product	Max Value	Date
A	111	01/10/2023
B	117	01/02/2023

Grateful for any help

[Anonymous · Accepted solution]

Hi @TimK ,

please using the following sytnax :

suma&b = SUM('Table (2)'[Value])

Table 2 = SUMMARIZE('Table (2)','Table (2)'[product],'Table (2)'[Attribute],"sum",[suma&b])

max = CALCULATE(MAX('Table 2'[sum]),FILTER(ALL('Table 2'),'Table 2'[product]=SELECTEDVALUE('Table 2'[product])))

and you can get the following result:

This is my testing PBIX file ,you can refer to it for better understanding.

Best regards, 

Community Support Team Selina zhu 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly