topic Re: First Occurrence : Duplicate in DAX Commands and Tips

First Occurrence : Duplicate

Chandrashekar — Wed, 21 Sep 2022 06:53:34 GMT

Hello,

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

Regards,

Chandrashekar B

Re: First Occurrence : Duplicate

Jihwan_Kim — Wed, 21 Sep 2022 08:35:15 GMT

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" )

Re: First Occurrence : Duplicate

Chandrashekar — Wed, 21 Sep 2022 09:12:58 GMT

Hello,

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

File: Sample Data

Regards,

Chandrashekar B

Re: First Occurrence : Duplicate

Chandrashekar — Wed, 21 Sep 2022 09:26:51 GMT

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

Re: First Occurrence : Duplicate

Chandrashekar — Thu, 22 Sep 2022 05:26:57 GMT

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

Re: First Occurrence : Duplicate

Chandrashekar — Mon, 26 Sep 2022 07:08:52 GMT

Hello,

Any solution?

Regards,

Chandrashekar B