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
4 years ago

hi amitchandak ,
Thank you so much for help.
I try your suggestion based on the PBIX file that you send, it working fine until I got a first daay of the month that start in sunday.  Please see image attached.

Basically, I need the start of the week for each monday is start from monday. Try to find any sollutions but stuck, but I found that maybe it can be fix it if start of the month dax is change to start from Monday.
Is it possible to change the query for the start month is start from monday.