Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

MID function returning error

Why is this happening?  

Need Help
  • Anonymous's avatar
    Anonymous
    10 years ago

    Anonymous It's because you're in the query editor. That uses a completely different language. MID is a DAX function. The M equivalent function is Text.Middle

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Anonymous It's because you're in the query editor. That uses a completely different language. MID is a DAX function. The M equivalent function is Text.Middle

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      ?  Am I doing it right? 

      • Anonymous's avatar
        Anonymous
        Not applicable
        10 years ago

        The M language is case sensitive. Text.Middle not text.middle