week start date and week end date

[vjnvinod]

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 error of year 1900 or something like that, see below screenshot

could you please help me how to find my week start date and week end date?

[ryan_mayu]

@vjnvinod 

try to change the datatype to whole number

[vjnvinod]

@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]

@vjnvinod 

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

[vjnvinod]

@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 output	week Ending Date output
3 July, 2021	3 July, 2021	9 July, 2021
4 July, 2021	3 July, 2021	9 July, 2021
5 July, 2021	3 July, 2021	9 July, 2021
6 July, 2021	3 July, 2021	9 July, 2021
7 July, 2021	3 July, 2021	9 July, 2021
8 July, 2021	3 July, 2021	9 July, 2021
9 July, 2021	3 July, 2021	9 July, 2021
10 July, 2021	10 July, 2021	16 July, 2021
11 July, 2021	10 July, 2021	16 July, 2021
12 July, 2021	10 July, 2021	16 July, 2021
13 July, 2021	10 July, 2021	16 July, 2021
14 July, 2021	10 July, 2021	16 July, 2021
15 July, 2021	10 July, 2021	16 July, 2021
16 July, 2021	10 July, 2021	16 July, 2021

[ryan_mayu]

@vjnvinod 

pls see the attachment below

[vjnvinod]

@ryan_mayu 

This is awesome, thanks so much

i need 2 more additional coloumn one for

month which starts from July, that should be P1, if its August P2 and so on ..

and week accordingly, in the format Wk1, Wk2, Wk3, Wk4 , so on

[ryan_mayu · Accepted solution]

@vjnvinod 

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)

[vjnvinod]

@ryan_mayu 

This is so cool, thanks so much, it worked like charm

[ryan_mayu]

you are welcome

[Greg_Deckler]

@vjnvinod Week Starting - Microsoft Power BI Community

[vjnvinod]

@Greg_Deckler 

thanks for the share, very overwhelming for me

I just need a simple formula to calculate week starting day and week ending day

week starts on saturday and week ends on friday