Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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 November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.