Forum Discussion

thinkvisual's avatar
thinkvisual
Frequent Visitor
7 years ago
Solved

Conditional formatting background colour for 'if text contains'

Hello!   I need some help with coniditional formatting. I have checked through all other posts on the topic before I have posted this but think my query may be slightly different. I have a list of ...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi thinkvisual 

    You may have a look at FIND function.

    Column =
IF (
    FIND ( "video", [URL], 1, -1 ) > 0,
    1, // If find 'video',the column get 1
    IF ( FIND ( "photo", [URL], 1, 0 ) > 0, 2, 3 )
) // If find 'photo',get 2,otherwise get 3

    Regards,

thinkvisual's avatar
thinkvisual
Frequent Visitor
7 years ago

v-cherch-msft Wonderful thank you. I have started working with some DAX today and i'm learning. Would you be able to explain what the numbers are doing in your code so I can understand what is happening please?

 

Column =
IF (
    FIND ( "video", [URL], 1, -1 ) > 0,
    1,
    IF ( FIND ( "photo", [URL], 1, 0 ) > 0, 2, 3 )
)

 

Thanks

David

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi thinkvisual 

You may have a look at FIND function.

Column =
IF (
    FIND ( "video", [URL], 1, -1 ) > 0,
    1, // If find 'video',the column get 1
    IF ( FIND ( "photo", [URL], 1, 0 ) > 0, 2, 3 )
) // If find 'photo',get 2,otherwise get 3

Regards,

  • thinkvisual's avatar
    thinkvisual
    Frequent Visitor
    7 years ago

    Thank you so much for your help, much appreciated. 

    David

    • v-cherch-msft's avatar
      v-cherch-msft
      Microsoft Employee
      7 years ago

      Hi thinkvisual 

      Kindly mark my answer as a solution if you feel that makes sense.

      Regards,