calculates Day wise sales total filtered by calendar table

[tabish]

Trying to get the sum of sales weekday-wise (mon, tue, wed,..) for the same period in both years (the cumulative sum till last completed week of  2020 vs the same period in 2019), using below measure & it gives cumulative sum (both year) correctly but needs to have the sum for each year separately.

SalesYTD till last week = VAR Maxweek = CALCULATE(MAX('Calendar'[Day of Year]), ALL('Calendar'), 'Calendar'[CurWeekOffset] = -1)

RETURN CALCULATE([Total sales], 'Calendar'[Day of Year] <= Maxweek)

if I modify & puts a filter on for a year, it shows all values blank; 

SalesYTD 2020 till last week = VAR Maxweek = CALCULATE(MAX('Calendar'[Day of Year]), ALL('Calendar'), 'Calendar'[CurWeekOffset] = -1)

RETURN CALCULATE([Total sales], 'Calendar'[Day of Year] <= Maxweek,

FILTER(ALL('Calendar'),'Calendar'[Year] = MAX('Calendar'[Year])))

if I put months on rows it works correctly.

[V-pazhen-msft · Accepted solution]

@tabish 

Try add a year filter in your measure:

SalesYTD till last week = 

VAR Maxweek = CALCULATE(MAX('Calendar'[Day of Year]), ALL('Calendar'), 'Calendar'[CurWeekOffset] = -1)

RETURN CALCULATE([Total sales], 'Calendar'[Day of Year] <= Maxweek,'Calendar'[Date].[Year]=MAX([Date].[Year]))

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@tabish , refer if my week blog can help

Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...