Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
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
Solved! Go to 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
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 )
Thanks for the solution.
Hi @Chandrashekar
Can you attach a screenshot of the excel sheet along with the formula?
Hello,
Please find attached excel data with Formula.
Sample Excel Data: Excel Sample Data
Regards,
Chandrashekar B
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
17 | |
15 | |
13 | |
10 | |
10 |