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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

nth weekday number of the month

Dear all,

 

i would like to count the nth weekday number by month in a calc column, how can this be done?

 

like this:

DateMonthYEARDOWNth dow
1-1-2018 00:001201811
2-1-2018 00:001201821
3-1-2018 00:001201831
4-1-2018 00:001201841
5-1-2018 00:001201851
6-1-2018 00:001201861
7-1-2018 00:001201871
8-1-2018 00:001201812
9-1-2018 00:001201822
10-1-2018 00:001201832
11-1-2018 00:001201842
12-1-2018 00:001201852
13-1-2018 00:001201862
14-1-2018 00:001201872
15-1-2018 00:001201813
16-1-2018 00:001201823
17-1-2018 00:001201833
18-1-2018 00:001201843
19-1-2018 00:001201853
20-1-2018 00:001201863
21-1-2018 00:001201873
22-1-2018 00:001201814
23-1-2018 00:001201824
24-1-2018 00:001201834
25-1-2018 00:001201844
26-1-2018 00:001201854
27-1-2018 00:001201864
28-1-2018 00:001201874
29-1-2018 00:001201815
30-1-2018 00:001201825
31-1-2018 00:001201835
1-2-2018 00:002201841
2-2-2018 00:002201851
3-2-2018 00:002201861
4-2-2018 00:002201871
5-2-2018 00:002201811
6-2-2018 00:002201821
7-2-2018 00:002201831
8-2-2018 00:002201842
9-2-2018 00:002201852
1 ACCEPTED SOLUTION
v-diye-msft
Community Support
Community Support

Hi @Anonymous 

 

Please use this formula:

Column  = ROUNDUP(DAY('Table'[Date])/7,0)

09.PNG

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

View solution in original post

2 REPLIES 2
v-diye-msft
Community Support
Community Support

Hi @Anonymous 

 

Please use this formula:

Column  = ROUNDUP(DAY('Table'[Date])/7,0)

09.PNG

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
vik0810
Resolver V
Resolver V

It can be calculated with this DAX

 

Nth dow = 1 + INT ( ( DAY ( 'Table'[Date] ) - 1 ) / 7 )

Helpful resources

Announcements
March Fabric Community Update

Fabric Community Update - March 2024

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

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.