Forum Discussion

jfinley1128's avatar
jfinley1128
Regular Visitor
9 years ago
Solved

Help with Measure for contains

I am using the Power BI Desktop App to build a report against an Azure storage table which contains error logging for our web services. I am trying to write a measure against the description column f...
Need Help
Tutorial Requests
  • v-micsh-msft's avatar
    v-micsh-msft
    9 years ago

    jfinley1128,

     

    Remove the parts which are red underlined, then input them manually, this should be syntax symbol errors.

     

    Errortype = iF(
               ISERROR(
                    SEARCH("Phone", AuditLog[Description])),
                    iF(
                     ISERROR(
                          SEARCH("Address", AuditLog[Description])),
                          iF(
                             ISERROR(
                             SEARCH("name", AuditLog[Description])),
                              "null",
                              "Name"),
                       "Address"),
                 "Phone")

    Or copy and paste the code from here.

     

    If any further assistance needed, please post back.

    Regards

jfinley1128's avatar
jfinley1128
Regular Visitor
9 years ago

Hi Michael,

 

Thanks for the assistance and providing a precise querry. I tried both pasting and typing in the querry and get the following error when I try to add the calculated column on the modeling tab: 

 

The following syntax error occurred during parsing: Invalid token, Line 1, Offset 155, “.

 

v-micsh-msft's avatar
v-micsh-msft
Microsoft Employee
9 years ago

jfinley1128,

 

Remove the parts which are red underlined, then input them manually, this should be syntax symbol errors.

 

Errortype = iF(
               ISERROR(
                    SEARCH("Phone", AuditLog[Description])),
                    iF(
                     ISERROR(
                          SEARCH("Address", AuditLog[Description])),
                          iF(
                             ISERROR(
                             SEARCH("name", AuditLog[Description])),
                              "null",
                              "Name"),
                       "Address"),
                 "Phone")

Or copy and paste the code from here.

 

If any further assistance needed, please post back.

Regards

  • jfinley1128's avatar
    jfinley1128
    Regular Visitor
    9 years ago

    This worked. Thankyou very much!

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi,

     

    Is it posible to search a string based on a measure?

     as SEARCH([Measure],Column Name)? I tried this one but it didnt work.

     

    Regards,

    Maddy