Forum Discussion

Chandrashekar's avatar
Chandrashekar
Resolver III
3 years ago

First Occurrence : Duplicate

Hello,   How to get first occurrence from duplicate based on multi conditions.   Regards, Chandrashekar B
Chandrashekar's avatar
Chandrashekar
Resolver III
3 years ago

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's avatar
Chandrashekar
Resolver III
3 years ago

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's avatar
    Chandrashekar
    Resolver III
    3 years ago

    Hello,

     

    Any solution?

     

    Regards,

    Chandrashekar B