cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

Wanted to Show Month Week Number ( For Ex :- June Week 1, June Week 2 .. etc , March Week 1 )

Hi Team,

 

I have date column in Power BI which shows every Monday of the week, Now I wanted to create a column which will show June Week 1, June Week 2 ... December Week 1.

 

If i use Weeknum then it is giving me numbers from 1 to 53 which i dont want.

 

Could you please help me resolve it.

 

Thanks,

Shubham

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Champion
Community Champion

Re: Wanted to Show Month Week Number ( For Ex :- June Week 1, June Week 2 .. etc , March Week 1 )

@ShubhamK 

Add this as a new column

Month-Week = 
VAR _DAY = DAY([Date]) RETURN

SWITCH( TRUE(),
    _DAY >= 1 && _DAY <= 7, "Week 1",
    _DAY >= 8 && _DAY <= 14, "Week 2",
    _DAY >= 15 && _DAY <= 21, "Week 3",
    _DAY >= 22 && _DAY <= 28, "Week 4",
    "Week 5"
)

Fowmy_0-1601323792444.png

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

 




View solution in original post

3 REPLIES 3
Highlighted
Memorable Member
Memorable Member

Re: Wanted to Show Month Week Number ( For Ex :- June Week 1, June Week 2 .. etc , March Week 1 )

hi @ShubhamK  - you can create a calucalated column in your date table as shown below 

 

Month = FORMAT([Date], "MMMM")
Month-Week-No = 'Calendar'[Month] & " " & "Week " & WEEKNUM('Calendar'[Date])
 
Month-Week-No.png
Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!
Highlighted
Helper IV
Helper IV

Re: Wanted to Show Month Week Number ( For Ex :- June Week 1, June Week 2 .. etc , March Week 1 )

Thanks for the reply. But in this case, in february it will show February Week 5  , i dont want that, for every new month counting should start from Week 1. 

 

ShubhamK_0-1601323111886.png

Thanks,

Shubham

Highlighted
Community Champion
Community Champion

Re: Wanted to Show Month Week Number ( For Ex :- June Week 1, June Week 2 .. etc , March Week 1 )

@ShubhamK 

Add this as a new column

Month-Week = 
VAR _DAY = DAY([Date]) RETURN

SWITCH( TRUE(),
    _DAY >= 1 && _DAY <= 7, "Week 1",
    _DAY >= 8 && _DAY <= 14, "Week 2",
    _DAY >= 15 && _DAY <= 21, "Week 3",
    _DAY >= 22 && _DAY <= 28, "Week 4",
    "Week 5"
)

Fowmy_0-1601323792444.png

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

 




View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors