Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
hello,
is there a way i can create some way i can parameterise a list in power query that populated the custom sql query?
the requirement is to execute this query for multiple end of month dates - p_date_param1 in ('2023-03-31','2022-12-30')
can those two dates there be populated by a dynamic list in power query - for eg a list of month end dates for the last year
thank you!
Hi @amrosullivan ,
Please check if list parameter the is what you want.
Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn
Best Regards
User | Count |
---|---|
91 | |
73 | |
68 | |
63 | |
55 |
User | Count |
---|---|
99 | |
88 | |
73 | |
60 | |
58 |