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
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