Forum Discussion

sdmikejr's avatar
sdmikejr
Helper I
9 years ago
Solved

How 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...
Need Help
  • ankitpatira's avatar
    ankitpatira
    9 years ago

    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.

     

ankitpatira's avatar
ankitpatira
Community Champion
9 years ago

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.

 

Ravin's avatar
Ravin
New Member
9 years ago

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

  • Abrahamlincoln's avatar
    Abrahamlincoln
    New Member
    9 years ago

    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.