Forum Discussion
anupambit1797
Mar 03, 2026Steel Contributor
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...
- 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
anupambit1797
Mar 03, 2026Steel Contributor
Attachment