Week vise comparison sales for the last 3 years

[vskreddy46]

i got one scenario as below we are having the sales report for the last 3 years by week.

for example 2018,2019 years is having the 52 weeks 2020  is having the 53 weeks.

my client is not willing to see the 0 as sales values for the 53rd week. so what was the best method to handle this values.

[v-caliao-msft]

@vskreddy46,

As smoupre said, if you use WeekNumber = WEEKNUM('Table'[Date]) to return your week number, then every year has 53 weeks.

Regards,

Charlie Liao

[vskreddy46]

Hi Charlie Liao,

My Calender is having from feb 1st Sunday to the Next year  jan Last Saturday 

for example:

FY2016:- jan 31st 2016 to 28th Jan 2017

FY 2017:- Jan 29th 2017 to jan 27th 2018

Thanks 

Saran

[Greg_Deckler]

How are you doing your WEEKNUM calculation? If I create a calendar table for 2010 to 2020, all years have 53 weeks.