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 ,

 

How about the result after you follow the suggestions mentioned in my original post?

 

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.