Forum Discussion

Chandrashekar's avatar
Chandrashekar
Resolver III
3 years ago

First Occurence : Multi Occurence

Hello,   How to get first occurence based on multi condition. Condition: Column A & Column B & Column C Expected result: Column D   PBIX: Sample File    Regards, Chandrashekar B
amitchandak's avatar
amitchandak
Super User
3 years ago

Chandrashekar , You need to add an index column in power query and then addfollwing column in DAX

 

Column = if( minx(FILTER(Sheet1, [Number] = EARLIER(Sheet1[Number])),[index]) = [index],1,0)

 

Power Query- Index Column: https://youtu.be/NS4esnCDqVw

  • Chandrashekar's avatar
    Chandrashekar
    Resolver III
    3 years ago

    Hello Amit,

    May I know how it is working as formula need to consider condition Column B & Column C as well.

     

    Regards,

    Chandrashekar B

     

     

     

    Regards,

    Chandrashekar B