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...
  • ankitpatira's avatar
    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.