Forum Discussion

N7Legend's avatar
N7Legend
Regular Visitor
3 years ago
Solved

Return boolean if value is contained in a non blanked column

Hello,   I try to add a boolean (True or False) if a substring is contained in a non blanked other column. Here is my sample data: Entreprise ID Modules 00505755 Traffic Monitoring - EVPL...
Need Help
  • Sahir_Maharaj's avatar
    Sahir_Maharaj
    3 years ago

    Hello N7Legend,

     

    You can modify your formula to use the Text.Contains function with the "EVPL" substring and the [Modules] column:

    = Table.AddColumn(#"Type modifié", "EVPL", each Text.Contains([Modules], "EVPL"))

     

    Let me know if you might require further assistance.

Sahir_Maharaj's avatar
Sahir_Maharaj
Icon for Super User rankSuper User
3 years ago

Hello N7Legend,

 

You can modify your formula to use the Text.Contains function with the "EVPL" substring and the [Modules] column:

= Table.AddColumn(#"Type modifié", "EVPL", each Text.Contains([Modules], "EVPL"))

 

Let me know if you might require further assistance.