Forum Discussion

nikhil425's avatar
nikhil425
Helper I
7 years ago

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


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

2 Replies