Ravi,

It could be a simple calculated field like this:

//Assuming [Parameter] is a date type and [Date] is the field in your data

[Date] <= [Parameter]

Then, you'd put that calculated field on the filter shelf and set the filter condition to true.

But, it's a little hard for me to say if that's the right specific answer to your question.  If it is not, would it be possible for you to post a packaged workbook, or at least some sample data?  (Even dummy data in the same format, if your data is sensitive).

Joshua

Hi Ravi,

If your parameter is a string parameter with values similar to 2009 Q1, 2009 Q2, etc. then, the calculation may look similar to the following:

(if [Choose your Quarter Parameter]>=(datename('year', [Order Date]) + " Q" + datename('quarter', [Order Date])) then

[Order Date] end)

Hope this helps!

-Tracy

Hi Tracy, long time no talk to, hope all is going well!

Could you post a workbook that shows how your formulas works, I'm just not getting it? Thanks,

--Shawn

Same to you Shawn! Sure, here's the workbook I made using Superstore.

-Tracy

Thanks Tracy, now I get it. You and I interpreted the question differently. I thought Ravi wanted current quarter and previous quarter ONLY returned. You understood it to be current quarter and ALL previous quarters, obviously, because that's what you coded [or "a la mode-ed", I guess.] And a happy TGIF to you!

--Shawn

Hi Ravi,

Would you be able to post your workbook (twbx file)? Or a screenshot of your view and calculation?

-Tracy