Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Need M Code to create new column with current week as "1"

I'm using a query to create a Date table. I need a column that shows the current week as "1"; next week as "2"; following week as "3"; etc.  The task is complicated because our work week starts on Sa...
  • Geradav's avatar
    6 years ago

    HI Anonymous ,

     

    The short answer is no, you won't find anything more direct than that. What you have is the best one can have.

     

    Regards

     

    David