Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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]
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 👍
Proud to be a Super User! | |
User | Count |
---|---|
94 | |
90 | |
79 | |
77 | |
71 |
User | Count |
---|---|
116 | |
106 | |
88 | |
64 | |
63 |