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

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.