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.

  • Abrahamlincoln's avatar
    Abrahamlincoln
    New Member
    9 years ago

    The easy way of preparing Microsoft Certifiactions exam is using pass4sure exam dumps. I found most of the questions from the dumps in the real exam. This is the best organization from certificated exam dumps. This site totally committed to provide 100% exact preparation material.