Use DAX formula instead of time period parameters in custom SQL query

[hannaheb]

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.

[hannaheb]

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.

[lbendlin]

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