Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 customers' data.
Currently, I am trying to write an AND statement as I would in Excel, except im using Power Query so I can reference to some Parameters which will be dynamic and often change with new systems.
my current formula is returning an error and I have tried many different way and researched but have failed so far, could really appreciate some help.
first I tried using an IF statement however i need simultaneous conditions instead of concurrent ones.
I create a new custom column in power query,
my current formula is; "=AND([Length]>#"Min Length",[Length]<#"Max Length"))"
but this returns an Error "Expression.Error: The name 'AND' wasn't recognized. Make sure it's spelled correctly."
Expression.Error: The name 'AND' wasn't recognized. Make sure it's spelled correctly.
Solved! Go to Solution.
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
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