Forum Discussion

Mage's avatar
Mage
Frequent Visitor
1 year ago
Solved

Loop in Power Query to get date

Hi, Basically I have a weekly plan through a whole month, the table may like this: The plan will be handled from 1st weekday(Start Day) to 4rd weekday(End Day) each week, I want to transform ...
General Comment
Need Help
  • slorin's avatar
    slorin
    1 year ago

    Hi Mage 

    Start Date

    Date.AddDays(Date.StartOfWeek([Date],0),[Start Day])

    End Date

    Date.AddDays(Date.StartOfWeek([Date],0),[End Day]) 

    Stéphane 

slorin's avatar
slorin
Super User
1 year ago

Hi Mage 

Start Date

Date.AddDays(Date.StartOfWeek([Date],0),[Start Day])

End Date

Date.AddDays(Date.StartOfWeek([Date],0),[End Day]) 

Stéphane 

Mage's avatar
Mage
Frequent Visitor
1 year ago

Thank you for the help, it reminds me a lot, but the actual will be more complex, I will post a new thread.

 

Regards