ISO DATE

[netanel]

Hi All,

To get the ISO Date for Year and Week i wrote the following formula:

ISOYear-WeekNumber = FORMAT(YEAR([FullDateAlternateKey]) & "-" & WEEKNUM([FullDateAlternateKey], 21),"0000-00")

The formula works fine in DAX when I put it in the graph
I can't arrange it according to the timeline

Would appreciate help

[Idrissshatila]

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 👍

Follow me on Linkedin

[netanel · Accepted solution]

@Idrissshatila 

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 set

This is the Solushion for case like that: https://gorilla.bi/power-query/create-iso-week-and-iso-year/

Thanks anyway!