Forum Discussion

SkorpionAAM's avatar
SkorpionAAM
Helper V
5 years ago
Solved

if custom column formula using M Language

I have table where i used  this funcation which working fine    if [operation_photo] = "" then "" else "***/1/layers/3633601/features/"&[ogc_fid]&"/"&"operation_photo/"&[operation_photo]&"/"&"?a...
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    Hi， SkorpionAAM 

    Take a try to  change your M code as below:

    = Table.AddColumn(#"Changed Type", "Custom", each if [operation_photo] = "" then "" else if Text.Contains([operation_photo], "https://") then [operation_photo]  else "***/1/layers/3633601/features/"&[ogc_fid]&"/"&"operation_photo/"&[operation_photo]&"/"&"?api_key=***")

    Please check my test pbix file for more details.


    If it doesn't meet your requirement,please feel free to ask.

     

    Best Regards,
    Community Support Team _ Eason

PhilipTreacy's avatar
PhilipTreacy
Super User
5 years ago

Hi SkorpionAAM 

Sorry no I don't get your point that's why I asked if you could provide some sample data and examples of expected results.

Phil

SkorpionAAM's avatar
SkorpionAAM
Helper V
5 years ago

 

 

So output will come like this 

https://*****/1/layers/3633601/features/"&[ogc_fid]&"/"&"operation_photo/"&[operation_photo]&"/"&"?api_key=*****

 

https://dev.tecsolutiongroup.com/imglist/Storage/02_196.jpg

 

 

and im usuing this M condition 

if [operation_photo] = "" then "" else "https://*****/1/layers/3633601/features/"&[ogc_fid]&"/"&"operation_photo/"&[operation_photo]&"/"&"?api_key=*****"