Forum Discussion

rpiboy_1's avatar
rpiboy_1
Helper V
3 years ago
Solved

Pass Text String as Function Name

Web.Contents is constrained to having a valid URL in the intial arguement in order to be able to refresh automatically in the PowerBI Service. Therefore, if the URL contains a geography the only way ...
Need Help
  • slorin's avatar
    slorin
    3 years ago

    Hi,

     

    With Fn_US, Fn_CA ... and not Fn-US, Fn_CA

     

    = Table.AddColumn(Source, "ColumnName", each Expression.Evaluate("Fn_"&[Geo]&"()",#shared))

     

    With Fn-US

    = Table.AddColumn(Source, "ColumnName", each Expression.Evaluate("#(#)""Fn-"&[Geo]&"""()", #shared))

     

    Stéphane 

slorin's avatar
slorin
Super User
3 years ago

Hi,

 

With Fn_US, Fn_CA ... and not Fn-US, Fn_CA

 

= Table.AddColumn(Source, "ColumnName", each Expression.Evaluate("Fn_"&[Geo]&"()",#shared))

 

With Fn-US

= Table.AddColumn(Source, "ColumnName", each Expression.Evaluate("#(#)""Fn-"&[Geo]&"""()", #shared))

 

Stéphane