Hey all, I have a simple DAX formula in Excel Powerpivot (NOT pbi)
I want to filter it so that if [X Column] contains the string "pablo", only then will the sum be calcaulted.
I've tried a bunch of different methods
For some reason 'containsstring' is not a function available
Go to Solution.
=CALCULATE ( sum(table[Sales]), FILTER (table, FIND ( "Pablo", Table[X Column],, 0 ) <> 0 ))
Note that the function FIND is case-sensitive. Check this link for details:
View solution in original post
Click here to learn more about the September 2022 updates!
Mark your calendars and join us on Thursday, September 29 at 11a PDT for a great session with Ted Pattison!