Unable to Pass Date Parameter to DAX Query using Import Mode

[nikhil425]

Hello there, 

I have been trying to figure this out myself, but after so many trials, I felt exhausted and wanted to get your help. I pointed my Power BI Desktop file to Analysis Service Tabular Database and importing data directly using DAX query. 

Below screen shot shows the DAX query and the corresponding Mquery on top

This works fine, because I am passing the date directly, however I wanted to pass the date as a parameter instead of hardcoding directly in the DAX query. 

Can you please me how to write the corresponding MQuery, I already created a parameter in Power query. I just wanted to reference that parameter below:


Appreciate, if anyone can help me solve this. 

Thank you,

Nik

[v-juanli-msft]

Hi @nikhil425 

Here are some guide documents:

PASS PARAMETER IN POWER QUERY

https://www.red-gate.com/simple-talk/sql/bi/power-bi-introduction-working-with-parameters-in-power-b...

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[nikhil425]

Hi @v-juanli-msft 
I have tried all the variations listed on the website already. For some reason I am getting the following error:

And I created there different input parameters (Year, QuarterEnd and Last date), because we always run the report on Quarter Ends. 

I am I doing something wrong?