Nesting AND, OR Commands - DAX

[lukeshaffer]

I've grouped projects from a dataset, with the groups reflecting what phase of the process they're in (4 total). I'm trying to create a graph to both show the phases and whether the projects are on track. The only way I can come up with doing this is nesting 4 AND functions inside an OR function, with the idea being that each AND function would correspond to on/off track for each phase. I can't seem to get this working. Here are the functions I have so far:

Sample AND Function

IF(AND('TM Dashboard'[Current Schedule Step (groups)] = "Phase 1 - Site Selection",'TM Dashboard'[Days Open]<72,"On Schedule", "Behind Schedule")

Initial (broken) Nested Function Idea

Schedule Status = IF(OR((AND('TM Dashboard'[Current Schedule Step (groups)] = "Phase 1 - Site Selection",'TM Dashboard'[Days Open]<72,"On Schedule", "Behind Schedule"),(AND('TM Dashboard'[Current Schedule Step (groups)] = "Phase 2 - Leasing & Design",'TM Dashboard'[Days Open]<140, "On Schedule", "Behind Schedule")))))))

Do any of you know how to get this working or have a better way of doing this?

Thank you!

[az38]

hi @lukeshaffer 

if I understand you correct try SWITCH()

Schedule Status = SWITCH(TRUE(),
AND('TM Dashboard'[Current Schedule Step (groups)] = "Phase 1 - Site Selection", 'TM Dashboard'[Days Open]<72), "On Schedule",
AND('TM Dashboard'[Current Schedule Step (groups)] = "Phase 2 - Leasing & Design", 'TM Dashboard'[Days Open]<140), "On Schedule", 
"Behind Schedule"
)

[Greg_Deckler]

Sample data would really help to understand what you are doing. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[lukeshaffer]

Thank you, @Greg_Deckler! I appreciate your patience, as this is the first time I've had a question I couldn't find answered elsewhere. I know it's got to be simple, but it's beyond me right now. Does this work for the data?

Days Open	Current Schedule Step (groups)	Schedule Status
352	Phase 1 - Site Selection
345	Phase 2 - Leasing & Design
305	Phase 3 - Permitting & Construction
274	Phase 4 - Move
262	Phase 1 - Site Selection
234	Phase 2 - Leasing & Design
234	Phase 3 - Permitting & Construction
196	Phase 4 - Move
193	Phase 1 - Site Selection
193	Phase 2 - Leasing & Design
183	Phase 3 - Permitting & Construction
177	Phase 4 - Move
177	Phase 1 - Site Selection
177	Phase 2 - Leasing & Design
177	Phase 3 - Permitting & Construction
176	Phase 4 - Move
176	Phase 1 - Site Selection
176	Phase 2 - Leasing & Design
171	Phase 3 - Permitting & Construction
171	Phase 4 - Move
168	Phase 1 - Site Selection
165	Phase 2 - Leasing & Design
151	Phase 3 - Permitting & Construction
119	Phase 4 - Move
113	Phase 1 - Site Selection
101	Phase 2 - Leasing & Design
101	Phase 3 - Permitting & Construction
92	Phase 4 - Move
87	Phase 1 - Site Selection
79	Phase 2 - Leasing & Design
78	Phase 3 - Permitting & Construction
78	Phase 4 - Move
71	Phase 1 - Site Selection
71	Phase 2 - Leasing & Design
71	Phase 3 - Permitting & Construction
57	Phase 4 - Move
45	Phase 1 - Site Selection
45	Phase 2 - Leasing & Design
45	Phase 3 - Permitting & Construction
45	Phase 4 - Move
28	Phase 1 - Site Selection
17	Phase 2 - Leasing & Design
16	Phase 3 - Permitting & Construction
11	Phase 4 - Move
11	Phase 1 - Site Selection
8	Phase 2 - Leasing & Design
8	Phase 3 - Permitting & Construction
8	Phase 4 - Move
8	Phase 1 - Site Selection
8	Phase 2 - Leasing & Design
7	Phase 3 - Permitting & Construction
2	Phase 4 - Move
1	Phase 1 - Site Selection
1	Phase 2 - Leasing & Design