How to display all four weeks for each month in matrix visual in power bi?

[Sameer_s27]

i need to display week 1 to week 4 for each month of my calendar table. it should display like week 1 , week 2 , week 3 , week 4 for jan then again same for feb month.

[Anonymous · Accepted solution]

Hi @Sameer_s27 ,
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:

Create a column

Weekinmonth = 
VAR a = 1 + WEEKNUM ( 'Table'[Date] )-WEEKNUM( STARTOFMONTH ('Table'[Date]))
RETURN
SWITCH(
    TRUE(),
    a = 1, "Week1",
    a = 2, "Week2",
    a = 3, "Week3",
    a = 4, "Week4",
    a = 5, "Week5"
)

Final output

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Sameer_s27]

Thank you for the help !