Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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 Table.Column(_,column_to_search)=value_to_find)),
    return = Record.Field(valid_row, column_were_to_get_the_value)
in
    return

 

 

 

Ive got this function, It searches a value on a table column and returns the value for another column on the same row. For some reason, It doesn´t work if the value specified Its a date. The column to search from Its supposed to be a unique index for the function to work properly

Need Help

3 Replies

  • AntrikshSharma's avatar
    AntrikshSharma
    Community Champion
    3 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      It returns a list, but its working inside an each context, wouldn´t that keep a single value from the list?

      • AntrikshSharma's avatar
        AntrikshSharma
        Community Champion
        3 years ago

        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")