Set Analysis Rolling Period

[#1]

Hi Experts,

I have created a dashboard. My requirement is want to show Last 15 Days Sales.

My expression is like this:

Sum({<Year=, Quarter=, Month=,Week=,  TransactionDate={'>=$(=DayStart(Max(TransactionDate), -14))<=$(=Max(TransactionDate))'}>} Sales )

But am getting overall 31 Days. Please help me how to achieve this

Thanks in Advance

[#2]

Thank You Every One!!

[#3]

Thank You Tresesco & Anil,

Yes, I don't have transactions on that days. Thank you for your support

[Anonymous]

Glad to Help you