Require Top 5 max values for particular columns

Hi Sohaib 

Based on your description,based on your code, you can try the following.

let
Source = Folder.Files("C:\Users\dell\Documents\Working\5 BBH working\Working\Tables source for BBH"),
Custom1 = Table.TransformColumns(Source, {"Content", each Table.PromoteHeaders(Csv.Document(_))} ),
Custom2 = Table.Combine(Custom1[Content]),
#"Changed Type" = Table.TransformColumnTypes(Custom2,{{"R99_DL_CODE_Usage_%", type number}, {"IuB_Limiting_%", type number}, {"VOICE_TRAFFIC_3G_Erl", type number}, {"UL_VOL_TOT_3G_GB", type number}, {"UL_VOL_SIG_3G_GB", type number}, {"UL_VOL_R99_3G_GB", type number}, {"UL_VOL_HS_3G_GB ", type number}, {"UL_THP_3G_kbps", type number}, {"Failures_3G", Int64.Type}, {"DROPS_3G", Int64.Type}, {"CALLS_3G", Int64.Type}, {"HS_USERS_3G", Int64.Type}, {"EUL_USERS_3G", Int64.Type}, {"DCR_3G_%", type number}, {"DL_VOL_TOT_3G_GB", type number}, {"DL_VOL_SIG_3G_GB", type number}, {"DL_VOL_R99_3G_GB", type number}, {"DL_VOL_HS_3G_GB", type number}, {"Total_TxPwr_dBm_Used", type number}, {"Total_TxPwr_Usage_%", type number}, {"NonHs_TxPwr_Usage_%", type number}, {"DL_THP_3G_kbps", type number}, {"DSSR_3G_%", type number}, {"CS_USERS_3G", type number}, {"CSSR_3G_%", type number}, {"AVAILABILITY_3G_%", type number}, {"Date New", type datetime}, {"Hour", Int64.Type}, {"Week of Year", Int64.Type}, {"pmCellDowntimeAuto", Int64.Type}, {"pmSumDlCode", Int64.Type}, {"pmUlTrafficVolumePsCommon", Int64.Type}, {"pmUlTrafficVolumeSrb136", Int64.Type}, {"pmSumAmr5900RabEstablish", Int64.Type}, {"pmSumBestAmr5900RabEstablish", Int64.Type}, {"pmUlTrafficVolumeSrb34", Int64.Type}, {"pmSumCs12RabEstablish", Int64.Type}, {"pmSamplesDlCode", Int64.Type}, {"pmDlTrafficVolumeCs57", Int64.Type}, {"pmSumBestAmr4750RabEstablish", Int64.Type}, {"pmTotNoRrcConnectReqPs", Int64.Type}, {"pmSamplesAmr4750RabEstablish", Int64.Type}, {"pmDlTrafficVolumePs8", Int64.Type}, {"pmDlTrafficVolumeSrbOnlyHs", Int64.Type}, {"pmDlTrafficVolumePsCommon", Int64.Type}, {"pmSumAmr12200RabEstablish", Int64.Type}, {"pmTotNoRrcConnectReqCs", Int64.Type}, {"pmSamplesPsHsAdchRabEstablish", Int64.Type}, {"pmUlTrafficVolumePsStr32", Int64.Type}, {"pmNoSystemNasSignReleasePs", Int64.Type}, {"pmDlTrafficVolumeAmrNbMm", Int64.Type}, {"pmDlTrafficVolumePsStr64", Int64.Type}, {"pmSumBestAmr12200RabEstablish", Int64.Type}, {"pmDlTrafficVolumeAmr7950", Int64.Type}, {"pmDlTrafficVolumeCs64", Int64.Type}, {"pmNoNormalRabReleaseSpeech", Int64.Type}, {"pmSamplesPsEulRabEstablish", Int64.Type}, {"pmNoRabEstablishSuccessPacketInteractiveHs", Int64.Type}, {"pmUlTrafficVolumePsStr128", Int64.Type}, {"pmSamplesCs12RabEstablish", Int64.Type}, {"pmUlTrafficVolumeCs57", Int64.Type}, {"pmSamplesAmr5900RabEstablish", Int64.Type}, {"pmUlTrafficVolumeCs12", Int64.Type}, {"pmNoLoadSharingRrcConnCs", Int64.Type}, {"pmDlTrafficVolumeSrb34", Int64.Type}, {"pmUlTrafficVolumeCs64", Int64.Type}, {"pmSamplesAmr12200RabEstablish", Int64.Type}, {"pmDlTrafficVolumeAmr5900", Int64.Type}, {"pmUlTrafficVolumePsIntEulFach", Int64.Type}, {"pmUlTrafficVolumeSrbOnlyEul", Int64.Type}, {"pmSamplesAmrWbRabEstablish", Int64.Type}, {"pmTotNoRrcConnectReqPsSucc", Int64.Type}, {"pmDlTrafficVolumePsStrHs", Int64.Type}, {"pmNoRabEstablishSuccessSpeech", Int64.Type}, {"pmUlTrafficVolumePsIntEul", Int64.Type}, {"pmSumPsEulRabEstablish", Int64.Type}, {"pmNoCellUpdateAttMultiCs", Int64.Type}, {"pmDlTrafficVolumeAmr4750", Int64.Type}, {"pmTotNoRrcConnectReqCsSucc", Int64.Type}, {"pmSumAmrWbRabEstablish", Int64.Type}, {"pmUlTrafficVolumePsStr16", Int64.Type}, {"pmUlTrafficVolumePs64", Int64.Type}, {"pmUlTrafficVolumePs8", Int64.Type}, {"pmDlTrafficVolumeSrb136", Int64.Type}, {"pmDlTrafficVolumePs128", Int64.Type}, {"pmUlTrafficVolumePs16", Int64.Type}, {"pmSumBestAmr7950RabEstablish", Int64.Type}, {"pmDlTrafficVolumeCs12", Int64.Type}, {"pmNoNormalNasSignReleaseCs", Int64.Type}, {"pmSumBestAmrWbRabEstablish", Int64.Type}, {"pmDlTrafficVolumePsIntHs", Int64.Type}, {"pmSumBestCs12Establish", Int64.Type}, {"pmSumPsHsAdchRabEstablish", Int64.Type}, {"pmNoSystemRabReleaseSpeech", Int64.Type}, {"pmDlTrafficVolumePs384", Int64.Type}, {"pmSumAmr7950RabEstablish", Int64.Type}, {"pmNoNormalNasSignReleasePs", Int64.Type}, {"pmNoCellUpdateSuccMultiCs", Int64.Type}, {"pmSumAmr4750RabEstablish", Int64.Type}, {"pmUlTrafficVolumePs384", Int64.Type}, {"pmDlTrafficVolumePsStr128", Int64.Type}, {"pmNoSystemNasSignReleaseCs", Int64.Type}, {"pmUlTrafficVolumeAmrNbMm", Int64.Type}, {"pmDlTrafficVolumePs64", Int64.Type}, {"pmNoRabEstablishAttemptSpeech", Int64.Type}, {"pmNoRabEstablishAttemptPacketInteractiveHs", Int64.Type}, {"pmUlTrafficVolumePs128", Int64.Type}, {"pmDlTrafficVolumePs16", Int64.Type}, {"pmSamplesAmr7950RabEstablish", Int64.Type}, {"pmDlTrafficVolumePsStr16", Int64.Type}, {"pmNoLoadSharingRrcConnPs", Int64.Type}, {"pmSumBestAmrNbMmRabEstablish", Int64.Type}, {"pmTotNoRrcConnectReq", Int64.Type}, {"pmTotNoUtranRejRrcConnReq", Int64.Type}, {"pmNoRrcReqDeniedAdm", Int64.Type}, {"pmNoRrcPsReqDeniedAdm", Int64.Type}, {"pmNoRabEstablishAttemptPacketInteractive", Int64.Type}, {"pmNoRabEstablishSuccessPacketInteractive", Int64.Type}, {"pmNoRabEstablishAttemptPacketStream128", Int64.Type}, {"pmNoRabEstablishSuccessPacketStream128", Int64.Type}, {"pmNoFailedRabEstAttemptExceedConnLimit", Int64.Type}, {"pmNoFailedRabEstAttemptLackDlAse", Int64.Type}, {"pmNoFailedRabEstAttemptLackUlAse", Int64.Type}, {"pmNoFailedRabEstAttemptLackDlChnlCode", Int64.Type}, {"pmNoFailedRabEstAttemptLackDlPwr", Int64.Type}, {"pmNoCellDchDisconnectNormal", Int64.Type}, {"pmNoSpeechDchDiscNormal", Int64.Type}, {"pmNoNormalRabReleasePacket", Int64.Type}, {"pmNoSystemRabReleasePacket", Int64.Type}, {"pmNoFailedAfterAdm", Int64.Type}, {"pmNoReqDeniedAdm", Int64.Type}, {"pmNoOfNonHoReqDeniedInteractive", Int64.Type}, {"pmTotalTimeDlCellCong", Int64.Type}, {"pmTotalTimeUlCellCong", Int64.Type}, {"pmNoOfTermSpeechCong", Int64.Type}, {"pmNoOfTermCsCong", Int64.Type}, {"pmNoOfIurTermHsCong", Int64.Type}, {"pmCellDowntimeMan", Int64.Type}, {"pmNoIncomingHsHardHoAttempt", Int64.Type}, {"pmNoIncomingHsHardHoSuccess", Int64.Type}, {"pmNoOutGoingHsHardHoAttempt", Int64.Type}, {"pmNoOutGoingHsHardHoSuccess", Int64.Type}, {"pmNoRlDeniedAdm", Int64.Type}, {"pmEnableHsHhoSuccess", Int64.Type}, {"pmEnableHsHhoAttempt", Int64.Type}, {"pmNoTimesCellFailAddToActSet", Int64.Type}, {"pmNoTimesRlAddToActSet", Int64.Type}, {"pmCmAttDlHls", Int64.Type}, {"pmCmSuccDlHls", Int64.Type}, {"pmRlAddAttemptsBestCellSpeech", Int64.Type}, {"pmRlAddSuccessBestCellSpeech", Int64.Type}, {"pmRlAddAttemptsBestCellCsConvers", Int64.Type}, {"pmRlAddSuccessBestCellCsConvers", Int64.Type}, {"pmRlAddAttemptsBestCellPacketLow", Int64.Type}, {"pmRlAddSuccessBestCellPacketLow", Int64.Type}, {"pmRlAddAttemptsBestCellPacketHigh", Int64.Type}, {"pmRlAddSuccessBestCellPacketHigh", Int64.Type}, {"pmNoHsCcAttempt", Int64.Type}, {"pmNoHsCcSuccess", Int64.Type}, {"pmNoRrcReqDeniedAdmDlChnlCode", Int64.Type}, {"pmNoRrcReqDeniedAdmDlHw", Int64.Type}, {"pmNoRrcReqDeniedAdmDlPwr", Int64.Type}, {"pmNoRrcReqDeniedAdmUlHw", Int64.Type}, {"pmNoRejRrcConnMpLoadC", Int64.Type}, {"pmNoOfNonHoReqDeniedHs", Int64.Type}, {"pmNoOfNonHoReqDeniedEul", Int64.Type}, {"pmNoFailedRabEstAttemptLackDlHwBest", Int64.Type}, {"pmNoFailedRabEstAttemptLackUlHwBest", Int64.Type}, {"pmNoDirRetryAtt", Int64.Type}, {"pmNoRabEstablishSuccessAmrWb", Int64.Type}, {"pmTotNoRrcConnectReqSuccess", Int64.Type}, {"pmNoOfNonHoReqDeniedSpeech", Int64.Type}, {"pmNoSystemRabReleaseCsStream", Int64.Type}, {"pmNoSystemRabReleaseCs64", Int64.Type}, {"pmNoSysRelSpeechSoHo", Int64.Type}, {"pmNoSysRelSpeechNeighbr", Int64.Type}, {"pmNoSysRelSpeechUlSynch", Int64.Type}, {"pmNoFailedRABEstAttemptLackDLHw", Int64.Type}, {"pmNoFailedRABEstAttemptLackULHw", Int64.Type}, {"pmNoRrcCsReqDeniedAdm", Int64.Type}, {"pmNackReceived", Int64.Type}, {"pmAckReceived", Int64.Type}, {"pmSumCapacityHsDschUsers", Int64.Type}, {"pmSamplesCapacityHsDschUsers", Int64.Type}, {"pmSumCapacityHsPdschCodes", Int64.Type}, {"pmSamplesCapacityHsPdschCodes", Int64.Type}, {"pmCapacityAllocRejHsDschUsers", Int64.Type}, {"pmCapacityAllocAttHsDschUsers", Int64.Type}, {"pmCapacityAllocRejHsPdschCodes", Int64.Type}, {"pmDlTrafficVolumeAmrWb", Int64.Type}, {"pmDlTrafficVolumeFachSrbOnly", Int64.Type}, {"pmNoLoadSharingRrcConn", Int64.Type}, {"pmNoRejRrcConnSpFlowCtrl", Int64.Type}, {"pmNoNormalRabReleasePacketUra", Int64.Type}, {"pmNoSystemRabReleasePacketUra", Int64.Type}, {"pmSumUlRssi", Int64.Type}, {"pmNoNonServingCellReqDeniedEul", Int64.Type}, {"pmNoServingCellReqDeniedEul", Int64.Type}, {"pmSamplesUlRssi", Int64.Type}, {"pmSumAckedBitsPqSpi00", Int64.Type}, {"pmSumAckedBitsPqSpi01", Int64.Type}, {"pmSumAckedBitsPqSpi02", Int64.Type}, {"pmSumAckedBitsPqSpi03", Int64.Type}, {"pmSumAckedBitsPqSpi04", Int64.Type}, {"pmSumAckedBitsPqSpi05", Int64.Type}, {"pmSumAckedBitsPqSpi06", Int64.Type}, {"pmSumAckedBitsPqSpi07", Int64.Type}, {"pmSumAckedBitsPqSpi08", Int64.Type}, {"pmSumAckedBitsPqSpi09", Int64.Type}, {"pmSumAckedBitsPqSpi10", Int64.Type}, {"pmSumAckedBitsPqSpi11", Int64.Type}, {"pmSumAckedBitsPqSpi12", Int64.Type}, {"pmSumAckedBitsPqSpi13", Int64.Type}, {"pmSumAckedBitsPqSpi14", Int64.Type}, {"pmSumNonEmptyUserBuffersPqSpi00", Int64.Type}, {"pmSumNonEmptyUserBuffersPqSpi01", Int64.Type}, {"pmSumNonEmptyUserBuffersPqSpi02", Int64.Type}, {"pmSumNonEmptyUserBuffersPqSpi03", Int64.Type}, {"pmSumNonEmptyUserBuffersPqSpi04", Int64.Type}, {"pmSumNonEmptyUserBuffersPqSpi05", Int64.Type}, {"pmSumNonEmptyUserBuffersPqSpi06", Int64.Type}, {"pmSumNonEmptyUserBuffersPqSpi07", Int64.Type}, {"pmSumNonEmptyUserBuffersPqSpi08", Int64.Type}, {"pmSumNonEmptyUserBuffersPqSpi09", Int64.Type}, {"pmSumNonEmptyUserBuffersPqSpi10", Int64.Type}, {"pmSumNonEmptyUserBuffersPqSpi11", Int64.Type}, {"pmSumNonEmptyUserBuffersPqSpi12", Int64.Type}, {"pmSumNonEmptyUserBuffersPqSpi13", Int64.Type}, {"pmSumNonEmptyUserBuffersPqSpi14", Int64.Type}, {"pmSumAckedBitsCellEulTti10", Int64.Type}, {"pmSumAckedBitsCellEulTti2", Int64.Type}, {"pmNoActive10msFramesEul", Int64.Type}, {"pmNoActive2msFramesEul", Int64.Type}}),
BufferTable = Table.Buffer(#"Changed Type"),
    Custom1 = Table.SelectRows(BufferTable,each let a=List.MaxN(List.Distinct(BufferTable[VOICE_TRAFFIC_3G_Erl]),5),
        b=[Utrancell]
in [Utrancell]=b and List.Contains(a,[VOICE_TRAFFIC_3G_Erl]))
in
    Custom1

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.