Forum Discussion

rhashhab's avatar
rhashhab
Frequent Visitor
3 years ago
Solved

How to get Week Ranges in Power BI ?

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

 

  • FreemanZ's avatar
    FreemanZ
    3 years ago

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

6 Replies

    • rhashhab's avatar
      rhashhab
      Frequent Visitor
      3 years ago

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

      • FreemanZ's avatar
        FreemanZ
        Super User
        3 years ago

        could you depict your expected result with a table?

  • rhashhab's avatar
    rhashhab
    Frequent Visitor
    3 years ago

    FreemanZ 

    Week Number

    1Jan-8Jan 

    9Jan-16Jan

    17Jan-24Jan

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

     

    • FreemanZ's avatar
      FreemanZ
      Super User
      3 years ago

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