Forum Discussion

Tajkment's avatar
Tajkment
New Member
2 years ago
Solved

Weeknum - weeks covering 9 days

Hi, I have been putting together a custom financial year callendar, i have realised that the Weeknum dax is returning the same week number for the range of 9 days, is there a way to fix it? Exa...
Edate
Longer Week
WEEKNUM
  • Greg_Deckler's avatar
    Greg_Deckler
    2 years ago

    Tajkment How about this? 

    Column 3 = 
    VAR __Date = [Date]
    VAR __StartDate = DATE( 2024, 7, 1 )
    VAR __StartDay = WEEKDAY( __StartDate )
    VAR __Result = COUNTROWS( FILTER( 'Calendar', [Date] <= __Date && [Date] >= __StartDate && WEEKDAY([Date]) = __StartDay ) )
RETURN
    __Result
Tajkment's avatar
Tajkment
New Member
2 years ago

Greg_DecklerYou are 100% right,  that is not what i would like,

any advices what should i use instead?

Thank you


  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Tajkment That would depend on what exactly you are trying to achieve. How is it supposed to work? When does your financial year start and end?

    • Tajkment's avatar
      Tajkment
      New Member
      2 years ago

      I am looking to generate an financial year callendar, The financial year runs from July to June, so i would get Financial Year,month, quarter, week, the week is starting on Monday,

      The end goal is to use this one as a slicer, so the end users will be able to filter the visualisations by year / quarter / month / week

      • Greg_Deckler's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity Champion
        2 years ago

        Tajkment How about this? 

        Column 3 = 
    VAR __Date = [Date]
    VAR __StartDate = DATE( 2024, 7, 1 )
    VAR __StartDay = WEEKDAY( __StartDate )
    VAR __Result = COUNTROWS( FILTER( 'Calendar', [Date] <= __Date && [Date] >= __StartDate && WEEKDAY([Date]) = __StartDay ) )
RETURN
    __Result