using
1 Topic
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 and the student booking date is greater than Jun 21. Below is what I have but it isn't bringing any values through. I have read a few posts and tried a few different things but still no luck. Any assistance is greatly appreciated. Sales Revenue Intensive only > Jun21 = CALCULATE ( SUM ( 'Sales Reports'[Sales Revenue] ), CONTAINSSTRING('Sales Reports'[Intake],"Intensive"), 'Sales Reports'[Student Booking Date] > DATE ( 2021, 5, 31 ) ) Cheers KarenSolved768Views0likes3Comments