Combining year and week to a unique ID

[Anonymous]

Hi guys, and thank you for all the great help this community offers. 

I've ran into a little issue. I need to comine two collumns containing year and week into one uniqe number. A global week number if you like. E.g the first week will need to have the uniqe ID of 1, next week 2 and so on. As i'm using the number at a later stage it needs to remain a value. 

Any suggestions for solutions? 

Cheers! 

[Anonymous]

Maybe just (year * 100) + week, so you get values like:

201701 (week 1 of 2017)

201702 (week 2 of 2017)

etc

?

Thx,

Scott

[Greg_Deckler · Accepted solution]

I actually created this once and put it in the Quick Measure gallery as "Sequential"

https://community.powerbi.com/t5/Quick-Measures-Gallery/Sequential/m-p/380231

[Anonymous]

Thank you! Great that you also include the Power Bi file so it can easily be studied!