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
Jihwan_Kim's avatar
Jihwan_Kim
Super User
3 years ago

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'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