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
Assuming that your data is in SQL, you could create a view that would result in a 4months to date data, you could then import that on to powerBI and then setup a scheduled refresh job everyday.
No Sir My Question is not related this..I made Last 4 month date stored in dateparam
But How i apply this in my table for filtering data
So no one known that how to apply these parameter to fact table for filtering data
