Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Hi @nikhil425
Here are some guide documents:
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.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.