Calculate Week Ending Date

[HenryJS]

Hi all,

How can I calculate the week ending date from a date column in power query?

I would like to find the week end (Sunday), for example, 06/08/20 would be 09/08/2020

Thanks,

[v-kelly-msft · Accepted solution]

Hi @HenryJS ，

In power query,add a query as below:

= Table.AddColumn(#"Changed Type", "Custom", each Date.EndOfWeek([Date],1))

And you will see:

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Greg_Deckler]

@HenryJS - Here is a DAX way of doing week ending.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Week-Ending/m-p/389293#M120

[amitchandak]

@HenryJS , In case of DAX code, please find

https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Powe...

Calendar in M

https://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-1-calendar-columns