Forum Discussion

dslForPBI's avatar
dslForPBI
Helper I
8 years ago

M language issue

OK..this makes no sense to me..I am trying to take a list of numbers and use them as part of a "List.Contains" for a filter...if I hardcode the number list as in:   each List.Contains({1,2,3...   ...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

When you change it to a parameter, are you sure you are feeding it a list and not a table?

  • dslForPBI's avatar
    dslForPBI
    Helper I
    8 years ago

    Thanks for your response Greg_Deckler!  I am sure it is not a table--which is why it seems like either an odd bug or something--here is a snippet of code with comments:

    //Prep for filter using a parameter (outboundcodes) which is just a comma-delimited list of values
    //

    //
    valForCodes = Value.FromText(outboundcodes),


    //This one works (hardcoded)
    tblIncludeStates = Table.SelectRows(tblFromDownload, each List.Contains({543,95,96,1359,1360,1104,1170,1172,93,1248,454,1361,92,97,-4,-3,-5,-7,-8,-2}, [Outstate_Code])),

    //This one doesn't (just results in an empty table

    //
    tblIncludeStates = Table.SelectRows(tblFromDownload, each List.Contains(valForCodes,[Outstate_Code])),

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      8 years ago

      Try this:

       

      //Prep for filter using a parameter (outboundcodes) which is just a comma-delimited list of values
//
//
valForCodes = Text.ToList(Value.FromText(outboundcodes)),

//This one works (hardcoded)
tblIncludeStates = Table.SelectRows(tblFromDownload, each List.Contains({543,95,96,1359,1360,1104,1170,1172,93,1248,454,1361,92,97,-4,-3,-5,-7,-8,-2}, [Outstate_Code])),
//This one doesn't (just results in an empty table
//
tblIncludeStates = Table.SelectRows(tblFromDownload, each List.Contains(valForCodes,[Outstate_Code])),
      • dslForPBI's avatar
        dslForPBI
        Helper I
        8 years ago

        Right..tried that..as well as trying to convert it to binary first..you just get an empty table as a result (no errors, data is fine when viewed in the applied steps)..like the filtering suddenly doesn't work..only other thing I haven't tried is changing the encoding value when converting to binary first, like perhaps the text encoding is different with hand-input values within the advanced editor (is all I can think of)..