Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
12 | |
11 | |
8 | |
6 |