Require Top 5 max values for particular columns

[Sohaib]

Hi everyone, I need help regarding the power query actually i want to groupby or need code where i can adjust the table in require form.

1. We have tables of 7 days hourly base data. For each day we have separate csv file.
2. The query we require is we took data from all 7 days or any days provided tables and it give us table with respect to top 5 values of column "VOICE_TRAFFIC_3G_Erl" with respect to "Utrancell" coloumn. Means no matter how many days data we provide it only took top 5 value data of "VOICE_TRAFFIC_3G_Erl" from these days . Means it check all the values of each date with hour respect and give us back the max top 5 value of all the data provided for 7 days. And all other relevant column included with it.
3. Currently I am attaching 5 days hourly data but it is not an issue as the query will automatically select the top 5 values from all the data. So whether it will be 5 days or any number of days it just has to select 5 top value "VOICE_TRAFFIC_3G_Erl"  in all the data with respect to unique "Utrancell" column. Means the last table have for every Utrancell we have 5 entries of data which is the top 5 values of "VOICE_TRAFFIC_3G_Erl" from all the days data provided and all other relevant columns included with it.

Tables data 
I have made the code but it actually repeat the same top 5 values of column "VOICE_TRAFFIC_3G_Erl" in each unique column "Utrancell". Please correct the code if any one can

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}}),
FilteredRows = Table.Group(#"Changed Type", {"Utrancell"}, {{"Max VOICE_TRAFFIC_3G_Erl", each (Table.SelectRows(#"Changed Type", each List.Contains(List.MaxN(List.Distinct(#"Changed Type"[VOICE_TRAFFIC_3G_Erl]),5),[VOICE_TRAFFIC_3G_Erl]))), type table}}),
CombineMax5VOICE_TRAFFIC_3G_Erl = Table.Combine(FilteredRows[Max VOICE_TRAFFIC_3G_Erl])
in
CombineMax5VOICE_TRAFFIC_3G_Erl

Please urgent help requires

[dufoq3 · Accepted solution]

Already solved here.

[v-xinruzhu-msft]

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.

[Sohaib]

Your code not working like it 

I thing the two times "in" used in the last portion of code causing forever to load or stuck in query other thing is "custom1"  name 2 times used which i had corrected in my code but still not loading.