Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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

 

Need Help
Show and Tell
  • Fowmy's avatar
    Fowmy
    5 years ago

    Anonymous 

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

    ________________________

    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

     




3 Replies

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    5 years ago

    Anonymous 

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

    ________________________

    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

     




  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    hi Anonymous  - 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])
     
    Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!
    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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. 

       

      Thanks,

      Shubham