Hey Hi,I am looking for a function to search a particular word from a given column.
Currently, I am Using
Column_name = SWITCH(
@Sai_Kumar , try like
Column_name = SWITCH(True(), SEARCH("Sai", PowerBI_Fact[Product],,0)>0, "Sai",PowerBI_Fact[Product])
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.