cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sdmikejr
Helper I
Helper I

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 fiscal year:

 

FYTD: if ([Calendar Date] > #date(2016, 3, 31) and [Calendar Date] < #date(2017, 4, 1)) then "FYTD" else null).

 

This is great, but I really don't want to set something up that is not on auto pilot. As a result, I have created 2 parameters, "CurrentFiscalStartDate" and "CurrentFiscalEndDate". (YAY!) 

 

I was not able to find documentation on this but feel this should be fairly easy for all you experienced gurus.

I would like to pass these 2 parameters in the above FYTD statement instead of using the static #date(2016...) dates. 

 

Can someone please help me on this ? I will definitely leave a solution point for you for those who come forward and try 🙂

1 ACCEPTED SOLUTION
ankitpatira
Community Champion
Community Champion

@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.

 

Capture.PNG

View solution in original post

5 REPLIES 5
jennyjfoy
Regular Visitor

We provide best & high quality Microsoft 70-247 certification dumps - pdf for success in exams. Now you can avail special discount offers on all exams content.

ankitpatira
Community Champion
Community Champion

@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.

 

Capture.PNG

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.

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.

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.