Forum Discussion

TaufikMaggangka's avatar
TaufikMaggangka
Icon for Helper II rankHelper II
5 years ago
Solved

Weekly Date-Start Date and End Date

Hi All, I am trying to create weekly range column(from monday to saturday) using addtional column week start date and week end date, but then realized that the start date not started in first date...
Date Parameter
weekly
  • Anonymous's avatar
    Anonymous
    5 years ago

    TaufikMaggangka 
    I used those 4 columns to achieve your requirement, see pbix at the end.

     

    Basically I split the days into 5 groups with 6 days each because you want the new week to be Monday to Saturdays.

     

     

    Then I use Rankx to get the new weekday.\

    New weekday = RANKX(FILTER(Sheet1,[Year]=EARLIER([Year])&&[Month]=EARLIER([Month])&&[Day (bins)]=EARLIER([Day (bins)])),Sheet1[Day],,ASC)

     

     

    Best regards
    Paul Zheng _ Community Support Team
    If this post helps, please Accept it as the solution to help the other members find it more quickly.

TaufikMaggangka's avatar
TaufikMaggangka
Icon for Helper II rankHelper II
5 years ago

Thanks so much amitchandak ,
would you like to send me the pbix file. it will be really helpfull ?