Forum Discussion

AndrewVDaz's avatar
AndrewVDaz
New Member
5 years ago
Solved

HELP with AND Statment Expression.Error: The name 'AND'

Hi all,   I am new to DAX, Power BI, Excel etc... I am an electrician by trade and I'm attempting to use these tools to assist me in analyzing automation equipment for its suitability from custo...
  • Jimmy801's avatar
    5 years ago

    Hello AndrewVDaz 

     

    the formula has to look like this (we are talkiing here about Power Query and not DAX)

    [Length]>#"Min Length" and [Length]<#"Max Length"


    If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
    Kudoes are nice too

    Have fun

    Jimmy