Forum Discussion
AndrewVDaz
5 years agoNew Member
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...
- 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
Jimmy801
5 years agoCommunity Champion
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