topic Re: Dax to sum the total using a relative date with a filter in DAX Commands and Tips

Dax to sum the total using a relative date with a filter

electrobrit — Thu, 21 Jan 2021 20:10:06 GMT

This seems kind of simple but I can't get it to work using a relative date filter and another filter.
I have a table with a close date and status.
If the status = Closed and close date is in last 2 months, I need to sum the total.

Name	Close_Date	Status	Total Revenue
A	12/31/2020	Closed	$12,000
B	12/4/2020	Closed	$18,000
C	11/26/2020	Closed	$150,000
D	1/1/2021	Open	$4,200
E	12/4/2020	Closed	$3,666
F	2/2/2021	Open	$15,000
G	3/5/2021	Open	$20,600

In this case, it would be $183, 666

Thank you for your help!

Re: Dax to sum the total using a relative date with a filter

Anonymous — Thu, 21 Jan 2021 20:24:26 GMT

Try the following measure

Measure = SUMX(FILTER('Table','Table'[Status]="Closed"),'Table'[Total Revenue])

Ensure you replace "Table" with your table name.

Re: Dax to sum the total using a relative date with a filter

electrobrit — Thu, 21 Jan 2021 20:43:00 GMT

Thank you, but the part that is missing is adding to that a relative date filter (close date in the last 2 months), how do I add that part into what you have provided?

Re: Dax to sum the total using a relative date with a filter

electrobrit — Mon, 25 Jan 2021 18:05:15 GMT

Anonymous this was not a solution. The orig request is adding a date filter in as well. was that an oversight in trying to help or were you just adding what you know for part of it?