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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
RMV
Helper V
Helper V

Week of month from Calendar

Hi,

 

I created a new table and apply calendar formula to generate date:

CALENDAR(DATE(2017,01,01),DATE(2017,12,31))

 

Is there any function to show the Week of Month using dax language?

What I mean by Week of Month is for example: 1 Jun 2017 is considered as Week 1 (in month of June)

 

Regards,

 

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

Hi @RMV,

 

You can simple add a calculated column to calculate the week of month: (use current week number -  month start week number)

 

Week of Month = 
var currentweek=WEEKNUM([Date],1)
var startWeek=WEEKNUM(DATE([Date].[Year],[Date].[MonthNo],1),1)
return
Currentweek-startWeek+1

5.PNG

 

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

2 REPLIES 2
v-shex-msft
Community Support
Community Support

Hi @RMV,

 

You can simple add a calculated column to calculate the week of month: (use current week number -  month start week number)

 

Week of Month = 
var currentweek=WEEKNUM([Date],1)
var startWeek=WEEKNUM(DATE([Date].[Year],[Date].[MonthNo],1),1)
return
Currentweek-startWeek+1

5.PNG

 

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

It works! Thanks, @v-shex-msft!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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