CALCULATED COLUMN HELP

[jrpoli2000]

Hi All,

Need help again with a calculated column for the scenario below:

INVOICE	ITEM	STATUS	FINAL STATUS
23797402	BEVERAGE	PENDING	DELIVERED
23797402	POULTRY	DELIVERED	DELIVERED
23797402	MEAT		DELIVERED
24296696	DAIRY	PENDING	DELIVERED
24296696	POULTRY	DELIVERED	DELIVERED
24912330	BEVERAGE	PENDING	PENDING

Desired output is the FINAL STATUS column where "DELIVERED" will be applied to all rows with the same INVOICE number as long as "DELIVERED" can be found in the STATUS column even if some entries are blank or "PENDING".

Many thanks in advance.

[Zubair_Muhammad · Accepted solution]

Hi @jrpoli2000

Try this Column

Final Status =
IF (
    CONTAINS (
        FILTER ( Table1, Table1[INVOICE] = EARLIER ( Table1[INVOICE] ) ),
        Table1[STATUS], "DELIVERED"
    ),
    "DELIVERED",
    "PENDING"
)

[jrpoli2000]

Thanks again!!!