Forum Discussion
sdmikejr
Helper I
Helper IHow to pass the date parameters in PQ Query?
I have created my date table dynamically using M and it spans 2 years back and 2 years forward. I have a step in my query that creates a calculated column to identify all dates for the current fisca...
sdmikejr Click on Advaned Editor for the query for FYTD and pass parameter you've created as below. I think there shouldn't be any issue in passing date parameter as long as your parameter type is date.
Hi Ankit,
Your answer perfeclty works fine when we pass single value in a parameter.
I was trying to pass multiple values through parameter but getting an error. I tried 'in' instead of '=' but no luck. Could you help me how to pass mutilple values in a parameter please?
Thanks
The easy way of preparing Microsoft Certification exam is using pass4sure exam dumps. Dumps4download provides the best of Microsoft Exam Questions with 100% Money back Guarantee. visit this site and check your exam preparations.