Forum Discussion

slavisha84's avatar
slavisha84
Helper I
5 years ago
Solved

How to aggregating values by Fiscal Week and Channel?

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 ...
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    5 years ago

    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