Wildcard search in PowerBI

  • 22 June 2023
  • 1 reply

Hi All,

I am trying to build a report in Power BI where I have a column “Course Type”. I have to generate sum on a certain column. The other column where I want to put Sumif condition has variation of eLearning (e-Learning, elearning, ELearning - Online etc.) and variation of Classroom (classroom, CLASSROOM - In Person etc.). Is there a way to calculate sum using wildcards like excel? Here is the excel formula which works perfectly 


But is there any similar DAX formula in Power BI? Thank you!

1 reply

Update - I was able to use SEARCH in DAX and this issue is resolved.