Forum Discussion
Solved
How to use date parameters in power query
Hello, I'd like to know if a date (e.g. YYYY-MM-DD) can be used as one of parameters in power query of Power BI desktop. As shown below, when adding actual dates in query, the system shows corre...
Hi MichaelShown
& is used to concatenate text strings. Your parameters S_DATE and E_DATE are both of date type, so one solution is to change both of them into Text data type.
Another option is to use Date.ToText or Text.From function to convert the parameter values to text type in the code directly:
"... Start_Date Between '" & Date.ToText(S_DATE, [Format="yyyy-MM-dd"]) & "' AND '" & Date.ToText(E_DATE, [Format="yyyy-MM-dd"]) & "' AND ... "Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
