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

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!