Do we have any function in Power BI Desktop similar to Excel INDEX function in Microsoft Excel?

[Tanuja_PBI]

Do we have any function in Power BI Desktop similar to Excel INDEX function in Microsoft Excel?. Kindly look into the data.

This is doctors appointment "start date" and "begin time" data from the sql. Data will be updated daily and I need the visual of the 5th row/record of the column named "start date" or all the columns of 5th row. Your solution would be appreciable if you have any idea about this requirement..

[Greg_Deckler]

@Tanuja_PBI Doesn't look like it. IN-K Excel to DAX Translation - Microsoft Power BI Community

Generally you add an Index column in Power Query. I did write a DAX Index once: The Mythical DAX Index - Microsoft Power BI Community.

Another way might be to use a RANKX to rank things but you'd have to define why that particular row is the "fifth" row. Unless you are sorting in Power Query Editor and using Table.Buffer, sort order is not guaranteed. I would use sorting, Table.Buffer and then add an Index in Power Query.