First Occurrence : Duplicate

[Chandrashekar]

Hello,

How to get first occurrence from duplicate based on multi conditions.

Regards,

Chandrashekar B

[Jihwan_Kim]

Hi,

I do not know what is your expected outcome and how your data model looks like, but I tried to create a sample like below.

Please check the below picture and the attahced pbix file.

It is for creating a new column.

First occurrence flag CC = 
IF (
    Data[Index]
        = MINX (
            FILTER ( Data, Data[Category] = EARLIER ( Data[Category] ) ),
            Data[Index]
        ),
    "FLAG"
)

[Chandrashekar]

Hello,

Thanks for the solution. However I need based on mutli condition(Attached)

File: Sample Data 

Regards,

Chandrashekar B

[Chandrashekar]

Hello,

I want to add one more condition i.e. field(2nd Condition) = 1 to existing dax.

May I know how to do it.

Regards,

Chandrashekar B

[Chandrashekar]

Hello,

Can I add one more condition in Dax formula. i.e. field(2nd Condition) = 1

First occurrence flag CC = 
IF (
    Data[Index]
        = MINX (
            FILTER ( Data, Data[Category] = EARLIER ( Data[Category] ) ),
            Data[Index]
        ),
    "FLAG"
)

Regards,

Chandrashekar B

[Chandrashekar]

Hello,

Any solution?

Regards,

Chandrashekar B