Forum Discussion

anupambit1797's avatar
anupambit1797
Steel Contributor
Mar 03, 2026
Solved

Conditional Formatting or a Specific Filter Rule

Dear Experts ,                     I have a data like below:- here the Column-O, txNumber can go from 1,2,3 (txNum=2 and 3 means a Retransmission), I want to filter all the pairs for all Transmissi...
  • m_tarler's avatar
    m_tarler
    Mar 04, 2026

    Oliver's Power Query is really nice but I think it is missing the txNumber=3 lines (I'm betting he can tweak it to include them)

    Here is a formula I used as a helper column:

    =IF([@txNumber]>1,
          [@tbSize],
          IFERROR(LET( r,ROWS(Tabelle1[[#Headers],[tbSize]]:[@tbSize])-1,
                  PRODUCT(TAKE(FILTER(
                          HSTACK(DROP([tbSize],r),DROP([txNumber],r)-1),
                          [@dlHarqProcessIndex]=DROP([dlHarqProcessIndex],r),
                          {0,0}),1))),0))

    the output is 0 if it isn't one of the resent lines or the tbSize value if it was (replacing this with just TRUE/1 would make the formula a little more simple but wanted it as a double check)

    as for my method (which may be flawed) was to include all lines that have a txNumber>1 or if it is 1 then look for the NEXT line that has the same HarqID and if that line has a txNumber>1 then include it (i.e. next time that HarqID is used was a re-transmit).

    I will try to attach the file separately