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).
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!
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,
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!
thank you for your reply.
I have created calculation but when i am dragging it to the text field i am getting CNTD instead of sum.Is there any way to get aggregation SUM ? i have created calculation where i need to give some condition using some text data also.
it showed error as "can't add float and string values". so i have added STR to dimension to resolve the error and also changed from cntd to ATTR but i am not able to generate axis because of ATTR.
We can get AXIS only if we aggregation SUM.
Would you be able to post your workbook (twbx file)? Or a screenshot of your view and calculation?