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,

 

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

 

File: Sample Data 

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