Forum Discussion
Table for parameter in Advanced Editor
FaasBoers , Check if you are hitting one of the limitation
It looks like I'm trying to do something that it's not made for.
This is my m query:
StartDate = StartDateParameter, //#datetime(2023, 1, 1,0, 0, 0),
EndDate = EndDateParameter, //#datetime(2023, 12, 31, 0, 0, 0),
Card = CardValueParameter,
Source = Sql.Database("MyData", "MyTable", [Query="
SELECT *
FROM MyTable
WHERE TimeStamp >= '" & DateTime.ToText(StartDate, "yyyy-MM-dd hh:mm:ss") & "' AND TimeStamp <= '" & DateTime.ToText(EndDate, "yyyy-MM-dd hh:mm:ss") & "' AND OperatorId = " & Text.From(Card) & ""])
in
Source
The "Card" table of my "Employees" list is binded to the CardValueParameter.
When I create a slicer for the "Card" field, the query changes. But when I create a slicer for the "Name" field nothing changes. I'm looking for a workaround