Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. 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
User | Count |
---|---|
14 | |
9 | |
7 | |
7 | |
6 |
User | Count |
---|---|
21 | |
11 | |
10 | |
10 | |
8 |