How to get Week Ranges in Power BI ?

[rhashhab]

Hi Power BI Community,

I need to get week ranges like this way :

1Jan-8Jan 

9Jan-16Jan

17Jan-24Jan

25Jan-31Jan ( If it's until 30th of Jan then get me until 30th) 

How to write this kind of DAX formula considering 30th and 31th case?

I want it for each month like this way without weeks interfering from 1 month with another month

[rhashhab]

@FreemanZ 

Week Number

1Jan-8Jan

9Jan-16Jan

17Jan-24Jan

25Jan-31Jan ( If it's until 30th of Jan then get me until 30th)

[FreemanZ · Accepted solution]

something like this?

WeekNumber =

VAR _day = DAY(Data[Date])

RETURN

SWITCH(

    TRUE,

    _day >= 1 && _day <= 8, "1-8",

    _day >= 9 && _day <= 16, "9-16",

    _day >= 17 && _day <= 24, "17-24",

     "24 onwards"

     )

[rhashhab]

Thank you so much for your help @FreemanZ  !

[FreemanZ]

you may create a new column with WEEKNUM function, then refer to the added column in your new measures or visuals.

About WEEKNUM

https://learn.microsoft.com/en-us/dax/weeknum-function-dax

[rhashhab]

@FreemanZ  I don't want to use week number. I want date to be the same format I mentioned above.

[FreemanZ]

could you depict your expected result with a table?