Forum Discussion

heygau's avatar
heygau
Helper I
3 years ago
Solved

Finacial week Number

I am Working on Sales Report based on Financial Year, Yes I am using Separate Calendar Table which has Finacial year 

 

Finacial Year - July 1st to June 30th 

 

1) First week number of finacial year   Starts on first Wednesday of the year , 


Would be really helful if i get help with DAX 

Need Help
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi heygau 

    try to add a column with this:

    WeekNum2 =
    VAR _value = WEEKNUM([Date]-2,2)-27
    RETURN IF(_value>0, _value, _value+52)
     
    i tried and it worked like this:

     

7 Replies

  • FreemanZ's avatar
    FreemanZ
    Super User
    3 years ago

    hi heygau 

    try to add a column with this:

    WeekNum2 =
    VAR _value = WEEKNUM([Date]-2,2)-27
    RETURN IF(_value>0, _value, _value+52)
     
    i tried and it worked like this:

     

    • heygau's avatar
      heygau
      Helper I
      3 years ago

      FreemanZ  Is it Possible it conteneous for next finacial Year, 

      Because 52nd week came back to first week of Year (Like Cycling)

      • FreemanZ's avatar
        FreemanZ
        Super User
        3 years ago

        you want the 1 in circle to be 53? like 52, 53, 54...?

  • heygau's avatar
    heygau
    Helper I
    3 years ago

    FreemanZ 

    In Our Business Every Wednesday we conduct Sale Week  That Starts First Wednesday of  Each Financial Year, Then Again Next Year also First wednesday of Next Financial Year Satrts Sale week 1.


    So, Once this Financial Year Ends, From Next July First Wednesday it Should reset to Sale week 1 

    • FreemanZ's avatar
      FreemanZ
      Super User
      3 years ago

      "July First Wednesday it Should reset to Sale week 1 ", i thought the solution covers that, or is there still something misconsidered?

      • heygau's avatar
        heygau
        Helper I
        3 years ago

        Beautiful, Its works Mate Thanks Well Done