Combine inline function in query

[t4r05]

Hi,
I'm trying to create a custom function and use it in a query. I'm able to create a function in PBI Desktop and then use it in query, but i need to comibne it in a query so instead:
let Source = OData.Feed("https://endpoint/odata"),
Bills_table = Source{[Name="Bills",Signature="table"]}[Data],
Result = Table.AddColumn(Bills_table, "MapValue", each Map(_[AmountBilled]))
in
Result
 
where Map is my function, I want to combine this with query. Is this achievable ?
 
 
let Map = (val as number) => if val > 10 then "a" else "b" <-- some functino defined before rest of query
let Source = OData.Feed("https://endpoint/odata"),
Bills_table = Source{[Name="Bills",Signature="table"]}[Data],
Result = Table.AddColumn(Bills_table, "MapValue", each Map(_[AmountBilled]))
in
Result

[v-jiascu-msft]

Hi @t4r05,

Could you please mark the proper answer as a solution?

Best Regards,
Dale

[v-jiascu-msft · Accepted solution]

Hi @t4r05,

You just need to remove the second "let". 

let 
    Map = (val as number) => if val >= 10 then "a" else "b", // -- some functino defined before rest of query
let Source = OData.Feed("https://endpoint/odata"),
    Bills_table = Source{[Name="Bills",Signature="table"]}[Data],
    Result = Table.AddColumn(Bills_table, "MapValue", each Map(_[AmountBilled]))
in
    Result

Best Regards,

Dale

[zoloturu]

Hi @t4r05,

Modify the name of the function and code as below on the screenshot and try again:

map

let 
    Source = (val as number) => if val > 10 then "a" else "b" 
in
    Source

Regards,

Ruslan