Forum Discussion
Solved
How to restrict data in query editor
Dear Team, I am new in power bi.i have a requirement. i have a table where 3 years data.but i want to load only 4 to 5 month's date's data.. how is possible in power bi..that it loaded only 4 t...
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
How to make parameter..
I go parameter then kindly tell me option what i select..query list,suggested value
Kindly help me