Forum Discussion

Chandrashekar's avatar
Chandrashekar
Icon for Resolver III rankResolver 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
Icon for Super User rankSuper 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
Icon for Resolver III rankResolver 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