Forum Discussion
How to restrict data in query editor
HI panipat1990,
I think you are talk about query parameter which create in query editor, right?
If this is a case, current query parameter can setting dynamic list from other query, but it not support setting dynamic value based on above list.
For your requirement, I'd like to suggest you direct use #"query name"['column name'] with list.max function to get dynamic value, then use it in filter steps.
Sample:
Regards,
Xiaoxin Sheng
Hi panipat1990
You can apply a filter by clicking the button at the end of a column header of your date column (as per (1)) and then choose a Date Filter that suits.
But i want to data only maxdate. How is it possible through parameter.
So do you mean a dynamic range of dates? eg, always the 4 months relative to the current date?
Yes Current date to last 4 month's data dynamic
