Any straight way to know the start month number as per Current FY?

CommunityMember126793
CommunityMember126793
in Modeling

Hi Friends, is there any formula / straight way to know the month number of the Current Fiscal Year? e.g. if the CURRENT FISCAL YEAR in Time Setting is as below

CommunityMember126793_1-1634481802570.png

Then Apr'2021 is first month of FY22. How to calculate like below?

TIME SCALE --> Apr  May  Jun  Jul ...... Mar

LINE ITEM -->     1       2       3      4  ...... 12

 

Please suggest!

Tagged:

Best Answer

  • TristanS
    TristanS
    Answer ✓

    Create a time module with line items and formula as per belowchilled0ut_0-1634498739932.png

     

    It should result in the following: (I've hidden some months so you can see the results across years)

    chilled0ut_1-1634498846786.png

     

Answers

  • anand.shekhawat
    anand.shekhawat

    @CommunityMember126793 

    Try this

    Step 1) Create a Time Calculation module as below

    anandshekhawat_0-1634483679381.png

    write the formulas as written above.

     

    Step 2) Create the data module with time as a dimension as shown below

    anandshekhawat_1-1634483783333.png

    Your result should look like below

    anandshekhawat_2-1634483877525.png

     

    ~Anand

     

    https://in.linkedin.com/in/anand-shekhawat-35645486

Categories