How to aggregating values by Fiscal Week and Channel?

[slavisha84]

Hello, 

I am trying to aggregate data by fiscal week and also by channel (Online/Store).
I have a Revenue that looks like this:

And i have FiscalCalendar table:

I need to create a new table where i will summarise the Revenue values by fiscal week and Channell storing each year's value in a separate column lik this: 

So far I was able to get a summary by fiscal week for each year but I need to add a Channel breakdown as well:

How do I add the Channel breakdown to this function?

If you need sample data, I am uploading it to the shared folder below:

https://1drv.ms/u/s!AhhZq1add5YwjYIvuASi76lCL3R1eA?e=sZQshq

[slavisha84]

@amitchandak Thank you, this worked. 

[amitchandak · Accepted solution]

@slavisha84 , Try a new table like

Summarize(revenue, Revenue[channel], FiscalCalendar[Week], "2020", calculate(sum(Revenue[revenue]), filter(FiscalCalendar,FiscalCalendar[Year] =2020))
, "2021", calculate(sum(Revenue[revenue]), filter(FiscalCalendar,FiscalCalendar[Year] =2021)))

if need move 2020 and 2021 to addcolumns , like your script