Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Using Previous Quarter

I am using the following formula but I got blank as a result. # Quote Previous Quarter = calculate(COUNT('Quote Request Tracker WA'[Unique Identifier]),PREVIOUSQUARTER('Quote Request Tracker WA'[QR ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 

Dont use .date,try the measure as below:

# Quote Previous Quarter = calculate(COUNT('Quote Request Tracker WA'[Unique Identifier]),PREVIOUSQUARTER('Quote Request Tracker WA'[QR Received.date]))  

 

 
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!