Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Tajkment
New Member

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?

Example below

Thank you in advance for any advice

Tajkment_0-1719927806184.png

 

1 ACCEPTED SOLUTION

@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


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

5 REPLIES 5
Tajkment
New Member

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

any advices what should i use instead?

Thank you


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



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

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

@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


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...
Greg_Deckler
Community Champion
Community Champion

@Tajkment Don't use EDATE? You are using EDATE with a -6. This means that August 29th through 31st will all return a date of February 29th, which is 6 months back from August. Since February doesn't have a 30th or 31st, those will both return 29th of February or last date in February. So, probably not what you want.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.