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 on...
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
ryan_mayu
Super User
Super UserAnonymous
is your date column date type? it looks like TEXT. it's because date type should be italic.