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
can you be more specific ? are you saying tht the date slicer you have is not filtering a table you have ?
i want to restrict data between max_date and Before 4 month to max date in dynamic
i made variable max_date=List.Max(Table[Sale]) And Before 4 month Ago date variable i created..
But When i set in my data filter it showing error...Kindly help me
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
Hey Expert Thanks
i Accept it