Count number by Date - Current date to the prior quarter

[jerryr125]

Hi - I have the following formula in a master measure:

Count({<[REQUESTDATE]={'>=$(=QuarterStart(Max(REQUESTDATE), -1))<=$(=Date(Max(REQUESTDATE)))'}>} [REQUESTDATE] )

Basically, I would like a count of requests for each Request for dates from the max REQUESTDATE (say today) to the first date of the quarter (10/1/2020).  

The formula gives me an 'OK' but when I display in a chart it does not work. Any thoughts ? 

Thanks - Jerry

[GaryGiles · Accepted solution]

I think you need to use " instead of ' in your set analysis:

Count({<[REQUESTDATE]={">=$(=QuarterStart(Max(REQUESTDATE), -1))<=$(=Date(Max(REQUESTDATE)))"}>} [REQUESTDATE] )

[jerryr125 · Accepted solution]

Thank you - that was the solution - appreciate it ! Jerry