Use a Date Parameter created in Power Query as a filter in a measure

[lkaneff]

I am attempting to retrieve a value from a parameter that I created in Power Query. My goal is to use this parameter in a CALCULATE function with a filter:
CALCULATE(SUM(value), FILTER('Date Table'[Date Column], 'Date Table'[Date Column] = <Power Query Parameter>)).
I tried converting the parameter to a date format in Power Query, but it didn't work. I also attempted using both the CONVERT and DATEVALUE functions to transform the parameter into a date, but neither approach yielded the expected result.  I know I can join a parameter to the calendar table, but if I have a lot of parameters I don't want to join a table every time.  What am I doing wrong?

My date Parameter in Power Query

[FreemanZ · Accepted solution]

hi @lkaneff ,

Power Query parameters are not accessible with DAX. 

But DAX has its own similar feature - "what-if parameter", check this:

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-what-if