topic Re: indentify first instance based on multi criteria power bi in DAX Commands and Tips

indentify first instance based on multi criteria power bi

Chandrashekar — Thu, 22 Sep 2022 06:16:20 GMT

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

Re: indentify first instance based on multi criteria power bi

tamerj1 — Thu, 22 Sep 2022 06:46:10 GMT

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

Re: indentify first instance based on multi criteria power bi

Chandrashekar — Thu, 22 Sep 2022 07:15:37 GMT

Hello,

Please find attached excel data with Formula.

Sample Excel Data: Excel Sample Data

Regards,

Chandrashekar B

Re: indentify first instance based on multi criteria power bi

tamerj1 — Thu, 22 Sep 2022 07:17:27 GMT

Chandrashekar
The link is not working

Re: indentify first instance based on multi criteria power bi

Chandrashekar — Thu, 22 Sep 2022 07:21:47 GMT

Hello,

Can you check now pls.

Sample data: Sample Data

Regards,

Chandrashekar B

Re: indentify first instance based on multi criteria power bi

tamerj1 — Thu, 22 Sep 2022 07:50:39 GMT

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 )

Re: indentify first instance based on multi criteria power bi

Chandrashekar — Thu, 22 Sep 2022 08:35:09 GMT

Thanks for the solution.