Forum Discussion
Multiple rows same values in one column but not another
I managed to figure out a solution. I duplicated the query and on the new query I filtered for "Rejected" and removed duplicate ticket numbers (In case 2 of the 4 rejected). I filtered the original query on just department "2b". I then merged the new one back with original one as a new column called "New Status". It made it so some of the "New Status" columns were blank, so I then added another column with the equation
if [#"New_Status"] = null then [Status] else [#"New_Status"])
This gave me the "Rejected" status if any person rejected it for that ticket.
Hi
Hope this will help
in Query Editor, add a conditional column as follows
or create a calculated column
Column =
IF (
CALCULATE (
COUNT ( Table1[Status] ),
FILTER (
ALLEXCEPT ( Table1, Table1[Ticked] ),
Table1[Index] < EARLIER ( Table1[Index] )
&& Table1[Status] = "Rejected"
)
)
>= 1,
"Rejected",
"un-Rejected"
)
v-juanli-msft:
The query option still has department 2b listed as "Open". I don't want to automatically list it as "Rejected", becuase there may be times when the ticket is still listed as open for all the people, so I do want "Open" to show up.
Ashish_Mathur:
The idea is exactly what I would like to do, but being I am pulling from a database, I am unable to add an another column to make a string.
It may not be psosible to do. But I figured I would just ask to see if anyone had an idea.
I managed to figure out a solution. I duplicated the query and on the new query I filtered for "Rejected" and removed duplicate ticket numbers (In case 2 of the 4 rejected). I filtered the original query on just department "2b". I then merged the new one back with original one as a new column called "New Status". It made it so some of the "New Status" columns were blank, so I then added another column with the equation
if [#"New_Status"] = null then [Status] else [#"New_Status"])
This gave me the "Rejected" status if any person rejected it for that ticket.