indentify first instance based on multi criteria power bi

[Chandrashekar]

Hello,

How to get first instance based on multi criteria. I have shared excel formula to get and for reference.

Sample Data: Sample Data 

Regards,

Chandrashekar B

[tamerj1 · Accepted solution]

@Chandrashekar 
Please refer to attached sample file. You need to addindex column using power query.

Result = 
VAR CurrentIndex = 'Table'[Index]
VAR CurrentTable = CALCULATETABLE ( 'Table', ALL ( 'Table'[Index] ) )
VAR FilteredTable = FILTER ( CurrentTable, 'Table'[Index] <= CurrentIndex )
RETURN
    IF ( COUNTROWS ( FilteredTable ) = 1, 1, 0 )

[Chandrashekar]

Thanks for the solution.

[tamerj1]

Hi @Chandrashekar 
Can you attach a screenshot of the excel sheet along with the formula?

[Chandrashekar]

Hello,

Please find attached excel data with Formula.

Sample Excel Data: Excel Sample Data 

Regards,

Chandrashekar B

[tamerj1]

@Chandrashekar 
The link is not working

[Chandrashekar]

Hello,

Can you check now pls.

Sample data: Sample Data 

Regards,

Chandrashekar B