Forum Discussion

DonPepe's avatar
DonPepe
Icon for Helper II rankHelper II
4 years ago
Solved

Convert List in Function

Hi,    My goal is to get all the working date for a service from a given Start date and a given End date knowing that I know only the day of week and the service validity.  Parameters :   Start ...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    Use this

    Table.AddColumn(
   Source, 
   "DateList", 
   each List.Select(
      List.Dates(
         Date.FromText(StartDate), 
         Duration.Days(Date.FromText(EndDate) - Date.FromText(StartDate)) + 1, 
         #duration(1, 0, 0, 0)
      ), 
      (x)=> Date.DayOfWeek(x) = Number.From([DAY_IN_WEEK])
   )
)
Vijay_A_Verma's avatar
Vijay_A_Verma
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

Use below to generate a list of Tuesday. Fit this in your code

= List.Select(List.Dates([StartDate],Duration.Days([EndDate]-[StartDate])+1,#duration(1,0,0,0)), each Date.DayOfWeek(_)=2)