Aggregate values by Year-Month

[d904490]

I am trying to combine the different values of same issue on same month under that month. example- combine all issue1 and issue 2 of August under month-year august 2018 with two colums issue1 and issue2 and same thing should happen for  September 2018,............January 2108.

[v-yuta-msft]

Hi d904490,

As a general solution, maybe you can use CONCATENATEX() and ALLEXCEPT() to concatenate two rows in every date. Please check if it can meet your requirement.

Regards,

Jimmy Tao