Forum Discussion
wi11iamr
Advocate II
Advocate IISelect value from table as input to PowerQuery DateKey function
Hi there, I have a Date Function which creates a DateKey, and this function takes a StartDate and EndDate as parameter. I've traditionally used the function with a List.Min and List.Max function...
Hi wi11iamr,
How about replacing Date.From with List.Min? As you said, there is only one single value returned.
= fnDateDim(List.Min( Table.Column( Table.SelectRows(dimDateRanges, each [Datetype] = "InstallationDate"), "StartDate")), Date.From("2017/06/30"), "en-us")Table.Column returns a list. Reference: https://msdn.microsoft.com/en-us/library/mt260736.aspx.
Date.From can't take a list as parameter. Reference: https://msdn.microsoft.com/en-us/library/mt260687.aspx
Best Regards!
Dale
v-jiascu-msft
Microsoft Employee
Microsoft EmployeeHi wi11iamr,
How about replacing Date.From with List.Min? As you said, there is only one single value returned.
= fnDateDim(List.Min(
Table.Column(
Table.SelectRows(dimDateRanges,
each [Datetype] = "InstallationDate"),
"StartDate")),
Date.From("2017/06/30"),
"en-us")Table.Column returns a list. Reference: https://msdn.microsoft.com/en-us/library/mt260736.aspx.
Date.From can't take a list as parameter. Reference: https://msdn.microsoft.com/en-us/library/mt260687.aspx
Best Regards!
Dale
- wi11iamr
Fantastic, thanks very mcuh v-jiascu-msft!!
