Forum Discussion
Function not working properly when dates are used
(table_to_find as table,column_to_search as text,value_to_find as any, column_were_to_get_the_value as text) =>
let
valid_row = Table.SingleRow(Table.SelectRows(table_to_find, each Tabl...
Anonymous Table.Column returns a list of values, are you supplying a list in the value_to_find parameter? If not then you are comparing list against scalar.
It returns a list, but its working inside an each context, wouldn´t that keep a single value from the list?
AnonymousYup, sorry my bad, I misunderstood the code, if it works for everthing else then you need to supply the date as a date type, how are you doing that right now?
= FxGetValue ( Dates, "Date", #date(2007, 01, 01), "Date")