If and DAX Measure error

[Anonymous]

Hi Experts

Getting an erorr with the following if measure (second if step)

Elasped RAG Status = IF(FACTNEWBI_IncidentAudit[Elapsed Time] >24, "Red", IF(FACTNEWBI_IncidentAudit[Elapsed Time] >=12 && <24, "Amber","")

[bcdobbs · Accepted solution]

Try the following. I think you were missing a bracket at the end and needed to give a specifc column after the &&

IF(
	FACTNEWBI_IncidentAudit[Elapsed Time] >24, 
	"Red", 
	IF(
		FACTNEWBI_IncidentAudit[Elapsed Time] >= 12 && FACTNEWBI_IncidentAudit[Elapsed Time] < 24, 
		"Amber",
		BLANK()
	)
)