Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi @ImkeF , @TomMartens
1. I created a paremeter called Level3 using ManagePAramter.
2. I have a query to do transformation called ExtractData
3. As the last step in the ExtractData query I want to pass the value in Level3 parameter.
4. Also next time when use Edit Parameters and change the value I should get a new set of rows based on the value entered.
How to acheive this ?
Cheers
CheenuSing
Solved! Go to Solution.
Sorry, was busy. Here is a good reference:
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
This missing bit might be how to use the parameter in the M code:
Perform the desired filter-operation by using a hardcoded value like this:
and then repalce it by a reference to your parameter:
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Sorry, was busy. Here is a good reference:
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
This missing bit might be how to use the parameter in the M code:
Perform the desired filter-operation by using a hardcoded value like this:
and then repalce it by a reference to your parameter:
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Hi @ImkeF,
By the time your reply arrived , I had done the same thing as suggested by you.
Just one more calrification , how to reference a table generated by a earlier query in another query.
I have a query called EMPMASTER. I am creating another query to filter records from the output table of this query, in another query to filter records using parameter values.
Cheers
CheenuSing
Hi @ImkeF,
Sorry for the trouble. I got it working , it was a typo error in the name of the previously stored query.
Thank you for your support at all times.
Cheers
CheenuSing
Hi @MarcelBeug,
If this is possible can you please advise the steps.
Cheers
CheenuSing
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |