cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
nikhil425 Frequent Visitor
Frequent Visitor

Unable to Pass Date Parameter to DAX Query using Import Mode

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

Dax query.JPG


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:
parameter.JPG

Appreciate, if anyone can help me solve this. 

 

Thank you,

Nik

2 REPLIES 2
Community Support Team
Community Support Team

Re: Unable to Pass Date Parameter to DAX Query using Import Mode

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 Frequent Visitor
Frequent Visitor

Re: Unable to Pass Date Parameter to DAX Query using Import Mode

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

 

Error.JPG

 

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?

 

 

 

 

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors