Wildcard search in PowerBI

  • 22 June 2023
  • 1 reply
  • 51 views

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 

=SUMIF($J$16:$J$100,"*learning*",$G$16:$G$100)

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. 

Reply