Forum Discussion
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
- v-juanli-msftCommunity Support
Hi nikhil425
Here are some guide documents:
Best Regards
MaggieCommunity 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.- nikhil425Helper I
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?