Forum Discussion
Helper IIFilter table buy row talue
create a parameter and use it the M Sentences. To be dynamic. If i change the parameter the filter is applied. Instead of 4 use the name of your parameter.
follow this link to know more about parameters
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
You can change the parameter value in Edit Query
Helper IIH Victor
you got a great coutry , i have been there spend few days in lima .
your answer is great , works fine ( now i understand what is M Sentence. )
one more question - how can I change in this
Date.Year(DateTime.LocalNow()) -4 )
the 4 to be as variable .
thanks
gidon
Community Champion
create a parameter and use it the M Sentences. To be dynamic. If i change the parameter the filter is applied. Instead of 4 use the name of your parameter.
follow this link to know more about parameters
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
You can change the parameter value in Edit Query
- gidon
hello Victor
it works Great
thanks
gidon