calculate time settings with out hard coding

kishoreanimi
kishoreanimi
in Modeling

HI All,

Capture.PNG

I want achecive below attached scenario without hard code.

in source if i enter y the result should be start week and end week

start week can find out by current period () and how can i find out end week without adding +52 or 53

same applice to below scenario y-1

Answers

  • AjayM
    AjayM

    Hi @kishoreanimi ,

    You can use end() function along with the source input, to identify your desired end of specific year, without having to add 52 or 53. I considered source module dimensioned by YEAR, for the week number input. Hope the below gives an idea of how you can use the result in your case.

    image.png

    image.png

    Cheers,

    Ajay

Categories