Forum Discussion
Chris_Gross
Microsoft
MicrosoftLAMBDA Examples: Distance between two cities
This post is the first of a series where we will be sharing out examples of lambdas. This is intended to highlight lambdas we have cooked up that show the power of this new super-charged function. Ad...
One thing with =LET function I dont undestand
On this example You use parameter as city datatype and col param.latitude
when I use folowing example
=LET(t1, SomeTable, XLOOKUP(7, t1[keycolumn], t1[valuecolumn]) - dont work
so .-operator works with variables but [] indexer don't work
I quess sometime might be usefull to have
=LAMBDA(SomeTable, Key, XLOOKUP(Key, SomeTable[KeyColumn], SomeTable[ValueColumn])) as named funktion
Reference on SomeTable returns an array, actually SomeTable[#Data], not the table. Thus t1 is array, not table.
