Forum Discussion
Solved
How to get weekdays from a date range
Hi everyone I am new here and hoping someone can help me find a solution to this powerquery problem: Let's say I have two columns with dates in them, one called "startdate" and one called "enddat...
= List.Transform({Number.From([StartDate])..Number.From([EndDate)},each Date.DayOfWeekName(Date.From(_)))
= List.Transform({Number.From([StartDate])..Number.From([EndDate)},each Date.DayOfWeekName(Date.From(_)))