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
v-easonf-msft
Community Support
Community SupportHi, 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 _ Eason