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

5 Replies

  • 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