Set fixed amount based on text of other column

[Anonymous]

Hey all,

I am trying to set a fixed amount based on a text from another column.

The column that contains the text (text = 'series') is called ALG_Omschrijving. The fixed amount has to be 10. 
Does anyone know how this can be achieved? I've tried some stuff with text.contains but that doesn't work for me. 

Thanks! 

[tackytechtom · Accepted solution]

Hi @Anonymous ,

Is it this you are looking for? 🙂

Here the code:

if Text.Contains([ALG_Omschrijving], "series") = true then 10 else null

Let me know, if this solves your issue! 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[Anonymous]

Worked perfectly! Thank you!