Forum Discussion

HenryJS's avatar
HenryJS
Post Prodigy
6 years ago
Solved

Calculate Week Ending Date

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,

Data Protection
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    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!

3 Replies