Forum Discussion
WEEKNUM problem [Beginner]
Hello everyone, I hope you are going well !
I have a small problem with my power bi. I have some dates and I use week num to get the week number from this date and everything is okay. EXCEPT for one special date 08/11/22 which is suppose to be Week 45 but Power BI considere 11/08/22 so it says Week 32. All my others dates are fine except this one. I checked my data and they are exactly the same for each date.
(Don't mind the "Semaine" column, it's handwritten compare to Week num).
It never happened to me and i'm kinda lost, can you help me please?
Thank you and have a good day 🙂
Henri
Hello, thank you to both of you! I was able to find a solution thanks to both of you!
I made my column "date" a real date, not text! Then I could use the first solution to get the week and format everything properly ! I just needed to do "minus 1" to get the proper week but everything is ok now 🙂
Thank you a lot !!
Henri Dethoor
3 Replies
Anonymous
is your date column date type? it looks like TEXT. it's because date type should be italic.
Hi, Anonymous
Can you show the formula you are currently using?
Have you tried "Change type" ->"Using Locale" in PQ to format the dates?
You can also try to create custom column in PowerQuery.
Best Regards,
Community Support Team _ EasonHello, thank you to both of you! I was able to find a solution thanks to both of you!
I made my column "date" a real date, not text! Then I could use the first solution to get the week and format everything properly ! I just needed to do "minus 1" to get the proper week but everything is ok now 🙂
Thank you a lot !!
Henri Dethoor
