Forum Discussion

FaasBoers's avatar
FaasBoers
New Member
3 years ago

Table for parameter in Advanced Editor

Hi, I'm using 3 parameters in my SQL query. I am using a slicer to change the value of the parameter. 

Parameters: StartDateParameter, EndDateParameter, CardValueParameter.

I've created a table "StartDate" and "EndDate" and binded these to StartDatePara en EndDatePara. In my report I have 2 slicers where I can select the date. On select the query changes. 

For CardValuePara I'm using an import table "Employees". Columns CardNumber, Name. I've binded CardValuePara to CardNumber. When I create a slicer for CardNumber everything work fine. But when I create a slicer for name, CardValuePara doesn't change. 

Does somebody have a solution for this?

Need Help

2 Replies

    • FaasBoers's avatar
      FaasBoers
      New Member
      3 years ago

      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