First Occurence : Multi Occurence

[Chandrashekar]

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]

@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]

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