Forum Discussion

vjnvinod's avatar
vjnvinod
Icon for Impactful Individual rankImpactful Individual
5 years ago
Solved

week start date and week end date

Hi    I need to calculate week start date and week end date for  a calendar i am trying to build my week starts on Saturday and week ends on Friday   I used week day function but i am getting er...
Need Help
Show and Tell
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago
    pls try this
    Column = if(MONTH('Date'[Start])=7,"P1",if(month('Date'[Start])=8,"P2"))
    week = "Wk"&roundup(('Date'[Date]-MIN('Date'[Date])+1)/7,0)
     
ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
5 years ago

vjnvinod 

try to change the datatype to whole number

  • vjnvinod's avatar
    vjnvinod
    Icon for Impactful Individual rankImpactful Individual
    5 years ago

    ryan_mayu 

     

    that doesn't give me week start date 

    i am trying to create a coloumn for Week start date & week End date, my week starts with saturday and Week ends with Friday

    how do i write this formula

    I tried something like this, doesn't calcualtes correctly

    Week Start Date = 'Date'[Date]+6-WEEKDAY('Date'[Date],1)
    • ryan_mayu's avatar
      ryan_mayu
      Icon for Super User rankSuper User
      5 years ago

      vjnvinod 

      what's the expected output? shows "start" for weekstart date and "end" for weekend date?

      • vjnvinod's avatar
        vjnvinod
        Icon for Impactful Individual rankImpactful Individual
        5 years ago

        ryan_mayu 

         

        see below table with output coloumn

        my date calendar in power bI

        Date = CALENDAR(date(2021,07,03),date(2022,06,30))

         

        Date(Input)week Starting Date outputweek Ending Date output
        3 July, 20213 July, 20219 July, 2021
        4 July, 20213 July, 20219 July, 2021
        5 July, 20213 July, 20219 July, 2021
        6 July, 20213 July, 20219 July, 2021
        7 July, 20213 July, 20219 July, 2021
        8 July, 20213 July, 20219 July, 2021
        9 July, 20213 July, 20219 July, 2021
        10 July, 202110 July, 202116 July, 2021
        11 July, 202110 July, 202116 July, 2021
        12 July, 202110 July, 202116 July, 2021
        13 July, 202110 July, 202116 July, 2021
        14 July, 202110 July, 202116 July, 2021
        15 July, 202110 July, 202116 July, 2021
        16 July, 202110 July, 202116 July, 2021