Forum Discussion
passing a calculated date parameter to multiple imports
- 9 years ago
Hi vanessafvg
What you could potentially do is the following.
In the Query Editor where you have created your Date going back 2 years, Convert this to a List.
Then create a new Parameter, when it asks for the Suggested Values, change this in the Drop Down to Query.
This will then give you an option for which Query to use.
You can now select the List that you converted above.
Now that you have it set as a Parameter, you can simply use this Parameter in your filters.
There is another way to do this, if it does not work, which is to manually create it in the Advanced Editor, but is a bit more complex. So if you can try the above suggestion first?
As long as you refresh the entire data model it should be dynamic
it doesn't seem to be working, i have pointed it to the list to pass to the parameter, but the parameter doesn't seem to be populating?