I have WTDdata table that contains ThisYearRevenue and LastYearRevenue summarized by week:
I need to create 4 more columns LastYearOnlineRevenue, LastYearStoreRevenue, ThisYearOnlineRevenue, and ThisYearStoreRevenue from another table (RevenueByDate) that looks like this:
W column in this table means Fiscal Week.
I tried using this aproach:
LastYearOnlineRevenue = SUMMARIZE(FILTER(ALL(FiscalCalendar),FiscalCalendar(FiscalWeek)),FiscalCalendar(FiscalWeek)), "LastYearOnlineRevenue",CALCULATE(SUM(RevenueByDate(Revenue)),FiscalCalendar(FiscalYear) = YEAR(TODAY())-1 && RevenueByDate(Channel) = "Online")
If you can help me with at least one column, I am assuming the logic will be the same for the other 3.
Thank you in advance.
Here is the location for sample data and .pbix file: