this is about the 4th question of this type in 2 days -
see the attached approach - filtering is not the preferred approach
but you can do this relatively easily with a parameter and the user interface will look the same
first create a numeric version of the date
then a parameter
then a filter
it returns this
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Previous_year_v10.2.twbx 78.1 KB
The problem with creating parameter is that it applies only to one column.
Whereas, my report requires to filter the whole report based on a single filter.
I can add the parameter condition like
and create other columns.
But the problem is that I have large number of columns to be displayed and in turn it requires enormous calculation.
Any way to overcome this??
Also parameters are not dynamic with data. For it to work properly, requires manual entry.
1 of 1 people found this helpful
a parameter is global - you create a filter based o the parameter as ZZ and I suggested that includes your this year and last year and you can apply that filter everywhere in your workbook
Thank you. I understood. Learnt new thing. I didn't know to create a filter for parameter control.
The other way of doing this without parameter is to union your data to itself, please find my updates attached.
1st, union your data to itself as below
2nd, create calculation fields, but this time, you have to create every single column you need in the view
And the result
Hope this helps
Previous_year_v10.2.twbx 109.0 KB
Was this a question on some sample exam - literally there were at least 3 separate posts in the past 24 hours - each focused on doing this with filters versus a parameter.
I understand what you said about need manual intervention to change the period - unless the filter is a date range filter anchored to today() then the user needs to intervene
you reference a large number of columns that need to be included in the calculation - are they all dates - if not then then it only takes a single filter of this type
year([Renewaldate])=[enter year]or year([Renewaldate]) = [enter year]-1 to filter the data but it is based on a parameter
Hey Jim!.. no.. This was my requirement of my assignment.