Forum Discussion
hannaheb
3 years agoNew Member
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 p...
lbendlin
Super User
3 years agoIf 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