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?