Forum Discussion
Custom Column - Nested IF / AND Formula
Hi Jgrohows ,
It appears you are trying to use the DAX code language in Power Query, although Power Query uses a language called "M".
In your example, the code would look something similar to this:
if [FacilityType] ="Hospital" and [CycleTime] < 10 then 5
else if [FacilityType] ="College" and [CycleTime] < 15 then 5
else if ...
Note, M is case sensitive: "and" and "else" and "if" need to be written in small letters.
Let me know if this helps 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Most Valuable ProfessionalHi Jgrohows ,
It appears you are trying to use the DAX code language in Power Query, although Power Query uses a language called "M".
In your example, the code would look something similar to this:
if [FacilityType] ="Hospital" and [CycleTime] < 10 then 5
else if [FacilityType] ="College" and [CycleTime] < 15 then 5
else if ...
Note, M is case sensitive: "and" and "else" and "if" need to be written in small letters.
Let me know if this helps 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/