Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Calculated Column with multiple AND & OR

Hi,  I need to create a calculated column with the following rules:  Write 1 IF: Project is within G0 to G5 and status is 1 and description field is blank  OR (Project is within G0 to G5 and ...
Calculated columns
DAX
  • SpartaBI's avatar
    SpartaBI
    4 years ago

    Anonymous try this:

     

     

     

    Overall Status =
IF(
	Initiatives[Stage] 
		IN {
			"Demand Qualification", 
			"G0 Approval", 
			"G1 Approval", 
			"G2 Approval",
			"G3 Approval",
			"G4 Approval",
			"G5 Approval"
		},
		IF(
			Initiatives[Status] = "0", 
			1,
			IF(
				Initiatives[Status] IN {"1","2"}
					&& Initiatives[Description] = BLANK().
				1,
				0
			)
		)
)

     

     

     



    Showcase Report – Contoso By SpartaBI



          

SpartaBI's avatar
SpartaBI
Community Champion
4 years ago

Anonymous try this:

 

 

 

Overall Status =
IF(
	Initiatives[Stage] 
		IN {
			"Demand Qualification", 
			"G0 Approval", 
			"G1 Approval", 
			"G2 Approval",
			"G3 Approval",
			"G4 Approval",
			"G5 Approval"
		},
		IF(
			Initiatives[Status] = "0", 
			1,
			IF(
				Initiatives[Status] IN {"1","2"}
					&& Initiatives[Description] = BLANK().
				1,
				0
			)
		)
)

 

 

 



Showcase Report – Contoso By SpartaBI