Forum Discussion
Solved
Custom Column - Nested IF / AND Formula
Hello, I am working on a project where I need to provide a numerical score from 1-5 based on two criteria: (1) facility type (cateogried as Text) and (2) Cycle time (measured in days and categor...
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/
Thank you very much! I appreciate your quick and very helpful response.