Forum Discussion
Sum 2 measures while excluding a date
I have a measure I need to create that will sum two values but not sum them if the date is a particular date range. I don't want to exclude the data from being in the total, but I don't want it to sum the 2 values together. Can anyone assist with the syntax of the Dax measure? Sample of the data attached. I would like to sum donatyion qty - ALL with Donor count but NOT sum if the date is X. If the date is X, then the value will be only the Donor count filed.
maybe you can try ,
=if(max('Date')=date(2023,3,22)||max('Date')=date(2023,3,23),[Donor Count], [Total Store Donor Count])
This is essentially an IF statement impacting the line values but not the total. Assuming dates to exclude is a hard coded range somethingl like this:
Total * = VAR DatesToExclude = CALENDAR ( DATE ( 2020, 3, 4 ), DATE ( 2020, 3, 10 ) ) VAR CurrentDate = SELECTEDVALUE ( Dates[Date] ) RETURN IF ( CurrentDate IN DatesToExclude, [Donor Count], [Donor Count] + [Donation ALL] )
4 Replies
maybe you can try ,
=if(max('Date')=date(2023,3,22)||max('Date')=date(2023,3,23),[Donor Count], [Total Store Donor Count])
This is essentially an IF statement impacting the line values but not the total. Assuming dates to exclude is a hard coded range somethingl like this:
Total * = VAR DatesToExclude = CALENDAR ( DATE ( 2020, 3, 4 ), DATE ( 2020, 3, 10 ) ) VAR CurrentDate = SELECTEDVALUE ( Dates[Date] ) RETURN IF ( CurrentDate IN DatesToExclude, [Donor Count], [Donor Count] + [Donation ALL] )
