Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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
Maybe just (year * 100) + week, so you get values like:
201701 (week 1 of 2017)
201702 (week 2 of 2017)
etc
?
Thx,
Scott
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
Thank you! Great that you also include the Power Bi file so it can easily be studied!
User | Count |
---|---|
101 | |
90 | |
79 | |
70 | |
70 |
User | Count |
---|---|
112 | |
96 | |
96 | |
75 | |
72 |