How to convet year week number to date

[Shalaka1]

Hi,

I have year and weenumber and I need to convert this to date 

for example : I have 202237 , here 2022 is date and 37 is weeknumber and I need to convert this to date without dax.

could you please help me to sort out this issue. 

Thanks.

[Ahmedx]

plse try this
Sample PBIX file attached
https://1drv.ms/u/s!AiUZ0Ws7G26Rh00C0uCitb4Nd7qQ?e=5s8ai9

[
Y = Number.From(Splitter.SplitTextByLengths({4, 2})( Text.From(
    [#"Year-week"])){0}),
W =Number.From(Splitter.SplitTextByLengths({4, 2})( Text.From([#"Year-week"])){1}),   
 D =  List.Select(
 List.Generate(()=>#date(Y,1,1),(x)=>x<=#date(Y,12,31),(x)=>Date.AddDays(x,1)),(x)=> Date.Year(x) = Y and Date.WeekOfYear(x)=W) 
     ][D]

[Idrissshatila]

Hello @Shalaka1 ,

check this solution https://community.powerbi.com/t5/Desktop/convert-week-number-into-data/td-p/88227

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin