Better way to structure multiple IF statements?

Question

Hello - I have the following requirements to group items into a single "Comments" column:

a) Status Column: Under Review
Testing Status: all items in this column
Status Column: Open
Testing Status: In First Review, In Second Review

The goal is to group these into the "Comments" column.
I created the if statements below, but it only returns 3 items. There are a total of 11 items returned when I apply these filters in the excel table.

Is there a better way to structure this? or what am i doing wrong where I only get 3 items? Any help is greatly appreciated!

if [Status]= "Under Review" and [Testing Status] = "In Progress"

then "Comments"

else if [Status]= "Under Review" and [Testing Status] = "In Review"

then "Comments"

else if [Status]= "Under Review" and [Testing Status] = "In Review #2"

then "Comments"

else if [Status]= "Under Review" and [Testing Status] = "Not Started"

then "Comments"

else if [Status]= "Under Review" and [Testing Status] = "Not Yet Tested"

then "Comments"

else if [Status]= "Under Review" and [Testing Status] = "Not Yet Tested 2"

then "Comments"

else if [Status]= "Under Review" and [Testing Status] = "Pending Evidence"

then "Comments"

else if [Status]= "Under Review" and [Testing Status] = "Tested by Team"

then "Comments"

else if [Status]= "Under Review" and [Testing Status] = ""

then "Comments"

else if [Status]= "Open" and [Testing Status] = "In First Review"

then "Comments"

else if [Status]= "Open" and [Testing Status] = "In Second Review"

then "Comments"

v-xicai · Accepted Answer

Hi Anonymous&nbsp;,
&nbsp;
You may change the power query codes like below in Query Editor.
&nbsp;
=if [Status]=  "Under Review" and

([Testing Status] = "In Progress"

or [Testing Status] = "In Review"

or [Testing Status] = "In Review #2"

or [Testing Status] = "Not Started"

or [Testing Status] = "Not Yet Tested"

or [Testing Status] = "Not Yet Tested 2"

or [Testing Status] = "Pending Evidence"

or [Testing Status] = "Tested by Team"

or [Testing Status] = "" )

then "Comments"

else

if [Status]=  "Open" and ([Testing Status] = "In First Review" or [Testing Status] = "In Second Review" )

then "Comments"
&nbsp;
Best Regards,
Amy&nbsp;
&nbsp;
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Better way to structure multiple IF statements?

2 Replies

Related content

Table structure

Multiple IF statements in DAX

ELT JSON / Semi structured

ELT JSON Semi Structured Loop

Multiple nested IF statements