Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Syntax Error in list

Hi All, Need your Help....for DAX Statement Trying to list some countries I want and show one thing if true, and another thing if false. Below gives an syntax error = Table.AddColumn(Custom1, "Da...
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Dong,

     

    Thanks for the reply...

     

    Am getting data type error message when using List.Contains

     

    = Table.AddColumn(#"Changed Type1", "Custom", each if List.Contains({“January", "February", "March", "April", "June", "July", "August", "September"},[Year])  then [Year] & [Day] else [Year])

     

    "Expression.Error: 10 arguments were passed to function which expects between 2 and 3. Details: Pattern= Arguments=List

     

    Regards,

    Sam

v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi Anonymous ,

 

Your formula is Power Query M formula and "IN" function is DAX function. We can change your formula to following to meet your requirement.

 

 

= Table.AddColumn(#"Changed Type1", "Custom", each if Text.Contains("January February March April June July August September",[Year])  then [Year] & [Day] else [Year])

https://docs.microsoft.com/zh-cn/powerquery-m/text-contains

 

Or

 

= Table.AddColumn(#"Changed Type1", "Custom", each if List.Contains({“January", "February", "March", "April", "June", "July", "August", "September"},[Year])  then [Year] & [Day] else [Year])

https://docs.microsoft.com/zh-cn/powerquery-m/list-contains

 

 

 

 

 

BTW, pbix as attached.

 

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Dong,

     

    Thanks for the reply...

     

    Am getting data type error message when using List.Contains

     

    = Table.AddColumn(#"Changed Type1", "Custom", each if List.Contains({“January", "February", "March", "April", "June", "July", "August", "September"},[Year])  then [Year] & [Day] else [Year])

     

    "Expression.Error: 10 arguments were passed to function which expects between 2 and 3. Details: Pattern= Arguments=List

     

    Regards,

    Sam

    • v-lid-msft's avatar
      v-lid-msft
      Community Support
      6 years ago

      Hi Anonymous ,

       

      Sorry for my mistake, use the following formula:

       

      = Table.AddColumn(#"Changed Type1", "Custom", each if List.Contains({{“January"}, {"February"},{ "March"}, {"April"},{ "June"},{ "July"}, {"August"},{ "September"}},[Year])  then [Year] & [Day] else [Year])

      Best regards,

      Community Support Team _ Dong Li
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.