Forum Discussion
Use DAX formula instead of time period parameters in custom SQL query
In a custom SQL query, time period parameters can be integrated, that can later be changed by the dashboard user and therefore the query runs in the background for this time period. Is there also a possibility to solve this via a DAX function? Basically it is about defining decils and assigning the data to those decils in relation to a time period.
3 Replies
- lbendlin
Super User
If your SQL Server is connected via Direct Query then you can use Dynamic M Query Parameters.
Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn
Thank you for answering! The problem with Dynamic M Query Parameters is, that you can only change them in the "backend" so there is no option in the "frontend" for the dashboard viewer, right?
- lbendlin
That's incorrect. You can bind DAX columns to the parameter.
