Skip to Content
0
Former Member
Jul 13, 2016 at 01:55 PM

Help creating Week Number in Query

1388 Views

I have experience creating and modifying BEX Queries, however, I have not written any formulas or variables in BEX before.

I have the requirement of creating week number based on a dimension called "Calendar Day"

I need 1/1/16 - 1/9/16 to be week 1 and then after that a typical Monday-Sunday week would follow.

Can someone please assist?