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!