DAX Assistance: How to Reference another Row with Duplicate Value

[Anonymous]

Hi, 

Urgent help required please if possible. I've attempted to find solution myself for hoursss, but not been able to. 

I have two columns in Power BI, which I will use to create a new column for my desired output (Move Type column). 

Column 1 (Type)

Column 2 (Delivery Number)

Desired Output (Move Type column) 

Delivery Number	Type	New Move Type	Duplicate?
305865793	Large	Large & Cases	True
305865793	Cases	Large & Cases	True
305865791	Large	Large	False
305865757	Cases	Cases	False
305865753	Large	Large & Cases	True
305865753	Cases	Large & Cases	True
305865726	Large	Large & Cases	True
305865726	Cases	Large & Cases	True
305865718	Large	Large & Cases	True
305865718	Cases	Large & Cases	True
305865716	Large	Large	False
305865715	Large	Large & Cases	True
305865715	Cases	Large & Cases	True
305865676	Large	Large & Cases	True
305865676	Cases	Large & Cases	True
305865669	Large	Large & Cases	True
305865669	Cases	Large & Cases	True
305865647	Large	Large	False
305865635	Large	Large & Cases	True
305865635	Cases	Large & Cases	True
305865197	Large	Large	False

IF [Delivery Number] is a duplicate, then I want to check the [Type] for all those individual duplicate Delivery Numbers

IF any of the [Type] for the duplicate Delivery Numbers is "Cases", then I want the [New Type] to return "Large & Cases" for all those Delivery Numbers. 

Unfortunately, I see no option to upload PBIX file

Thanks in advance

Matt

[Anonymous]

This is exactly what I was looking for. Thank you so much

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

Those are for creating new columns.

New Move Type CC = 
CONCATENATEX (
    FILTER ( data, Data[Delivery Number] = EARLIER ( Data[Delivery Number] ) ),
    Data[Type],
    " & ",
    Data[Type], DESC
)

Duplicate CC = 
COUNTROWS (
    SUMMARIZE (
        FILTER ( data, Data[Delivery Number] = EARLIER ( Data[Delivery Number] ) ),
        Data[Type]
    )
) <> 1