Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a custom dimension for Year Week# as follows:
= Year(Date) & ' ' & (Week([Date])
How would I make the week # always appear as two digits for example
2018 01
2018 02
etc.
Thanks.
It should be as below.
= Year(Date) & ' ' & num( Week([Date]), '00')