Forum Discussion
agonciulea2
3 years agoNew Member
Assign Date range value to sql Declare
Hello,
im trying to assign start and end date value to a sql Declare stament.
I know i can do a slicer or a datarange filter but there is more complixed items to the query
does anyone know if this is possiable? below is a basic statment i testing with.
Thank you
Declare @startDate date = ?
Declare @endDate date = ?
Select
Count(SO_ID)
from Sales
where ORDER_DATE between @startDate and @endDate
1 Reply
- amitchandakSuper User
agonciulea2 , You have to use m parameters or dynamic M parameters
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters