Forum Discussion

speedramps's avatar
speedramps
Icon for Super User rankSuper User
5 years ago
Solved

Parameter for Date.StartOfWeek([Date],Day.fieldname)

In Power Query the following command will return the Monday start of week for the Date Date.StartOfWeek([Date],Day.Monday)   and this command will return the Sunday start of week for the Date Dat...
Need Help
  • CNENFRNL's avatar
    CNENFRNL
    5 years ago

     

    Use 0/1/2..6 as the second parameter,

    = Date.StartOfWeek(Date.From(DateTime.LocalNow()), 1)

     

CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
5 years ago

 

Use 0/1/2..6 as the second parameter,

= Date.StartOfWeek(Date.From(DateTime.LocalNow()), 1)