Forum Discussion
Using CONTAINS to filter a column
Hi All I am trying to sum a column of $ values with a filter being applied to 2 other columns. e.g., I want to sum the sales revenue column when the Intake column CONTAINS the word Intensive a...
Hi Anonymous
You measure is correct and works well.
I checked that with sample data and resualt for >Jun21 and >Jul21 are as below:
The measure amitchandak shared has more advantages for you as you can see that on the table.
Please share the data in the table format to be able to review that.
Did I answer your question? Mark my post as a solution!
Appreciate your Kudos !!
VahidDM
Super User
Super UserHi Anonymous
You measure is correct and works well.
I checked that with sample data and resualt for >Jun21 and >Jul21 are as below:
The measure amitchandak shared has more advantages for you as you can see that on the table.
Please share the data in the table format to be able to review that.
Did I answer your question? Mark my post as a solution!
Appreciate your Kudos !!