Forum Discussion
ISO DATE
Hi All,
To get the ISO Date for Year and Week i wrote the following formula:
I can't arrange it according to the timeline
It's definitely an option I've already tried,
The problem is that the date order in my case went wrong
In any case, I found the problem and it is in my data setThis is the Solushion for case like that: https://gorilla.bi/power-query/create-iso-week-and-iso-year/
Thanks anyway!
2 Replies
Hello netanel ,
You need to create a sorting column so you could sort the date column you're using.
check this out
https://radacad.com/sort-a-column-with-a-custom-order-in-power-bi
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
It's definitely an option I've already tried,
The problem is that the date order in my case went wrong
In any case, I found the problem and it is in my data setThis is the Solushion for case like that: https://gorilla.bi/power-query/create-iso-week-and-iso-year/
Thanks anyway!
