Forum Discussion

IF's avatar
IF
Post Prodigy
5 years ago
Solved

Week 53

Hi,   I get data from SAP BW and use the weekly table to get the data.   This code generates 53.2019 and 53.2018, which is not correct. How could I improve it?   The code is: let     Source =...
Need Help
MFelix's avatar
MFelix
Super User
5 years ago

Hi IF 

 

Not sure if this is the correct option about your data but believe that you only consider 53 weeks on leap years, if this is the fact change your week.year column to the following code:

 

if Date.IsLeapYear([Date])  
then

Text.PadStart(Number.ToText(Date.WeekOfYear([Date])),2,"0")

& "." &

Number.ToText(Date.Year([Date])) else  if  Date.WeekOfYear([Date]) = 53  then  Text.PadStart("1",2,"0")

& "." &

Number.ToText(Date.Year([Date]) + 1 ) else Text.PadStart(Number.ToText(Date.WeekOfYear([Date])),2,"0")

& "." &

Number.ToText(Date.Year([Date]))

 

In this case I'm picking up the week were the number is 53 and making it on the first week of the other year.