Calculate First/Last Week

hyudolee
hyudolee
in Modeling

I want to calculate First/Last Week Like this picture.

I set the "General Week" as Time Setting.

I have no idea to do it.

hyudolee_0-1631597525388.png

 

Tagged:

Answers

  • Ingilavicus
    Ingilavicus

    Hi @hyudolee ,

     

    Any particular reason for using General weeks? Not sure how to get it there as we can't retrieve a month, but with the 445 week calendar you can do it like this, maybe helps you out: 

    Ingilavicus_0-1631600910308.png

    Ingilavicus_1-1631600929867.png

     

    Andris

     

     

  • rob_marshall
    rob_marshall

    @hyudolee 

     

    This is the type of stuff I was mentioning yesterday on the other post that setting your timescale to something other than General 13 weeks would save you a lot of time and headaches.

     

    Rob

  • hyudolee
    hyudolee

    @rob_marshall 

    @Ingilavicus 

     

    OK. I understand.

    I will try another solution.

     

    Thank you !

Categories