Filter Function or any Logic
Dear Experts, I have a data like below , Column "H" has rnti's , Column "F" has sfn which can range from 0~1023( and once 1023 it shall start again from 0) slots that can range from 0~9, each sfn(say 252) has slots(0~9), Column "J" is Sn( Sequence number) , In Output , I want like this, example for the rnti 384, column "B" = count of spdu-1 for the rnti=384, and so on How the spdu-1 counted? (spdu-x's are counted per rnti & per-rlcCtrlAckSn_ ,) as below for example for rnti==384, Thanks in Advance, I posted this earlier also , not sure why post got deleted somehowHow to highlight duplicated sequential rows
I have a data like below sfn can range from 0~1023, and then again start with 0, slots can range from 0~19 I want to highlight the rows like below:- so, 331.12 is repeated in ROWS(4,5) so highlighted in Yellow, 331.13 is repeated in ROWS(6,7) so highlighted in Yellow and so on. if any Conditional formatting or anyother logic, by which we can highlight these data , would be helpful. Worksheet attached. Br, AnupamJoin the Fabric Partner Community for an AMA with Kim Manis
🌟 Exciting News for the Fabric Partner Community! 🌟 Join us for a special AMA (Ask Me Anything) session with the Fabric Leadership Team, featuring Kim Manis, CVP of Product Management for Microsoft Fabric Platform! This is your chance to connect directly with the leaders shaping the future of Microsoft Fabric, ask your platform-related questions, provide feedback, and gain insights into upcoming innovations. 🗓️ Date: Thursday, December 4 ⏰ Time: 8–9 am PT 🔗 Submit or upvote your questions now: https://lnkd.in/gKNBvMKq To participate, make sure you’re a member of the Fabric Partner Community Teams Channel. If you haven’t joined yet, sign up here: https://lnkd.in/g_PRdfjt Don’t miss this opportunity to engage with the Fabric Leadership Team and help shape the future of data platforms!
Power Query - Large Data Set Question
Hello - I combined a handful of .xlsx files and there's about 5 million rows total. I'm trying to identify duplicate "project IDs" (the long strings below in rows 22-29), basically what this filter is showing is all of the project IDs that have 3, 4, 5, 6, etc. duplicates all the way through 14. That's exactly what I'm looking for, there's about 180k project IDs I was able to get. The problem is the project IDs that have 1 duplicate, which is the number 2 in this filter because I did a group by in power query by the project ID and it counts the number of matching rows it has, so 2 means it has 1 duplicate. When I filter on this it runs over the 1 million excel row limit, I was wondering if anybody had an idea of how I could get around this problem?Calculation formula for repetition entries
Dear Experts, I have a data like below in Home-Worksheet :- In Output, I want to calculate the count of spdu-1, spdu-2 per rnti... spdu-1 for rnti( say 384) is calculated as :- Sfn can range from 0~1023( and will start again once 1023 reached) and for each sfn (slot can range from 0~9) Thanks in Advance, Br, AnupamUnderstanding the Microsoft MVP Program: Seeking Clear Guidance
Hello everyone, I’d like to start a discussion about the Microsoft Most Valuable Professional (MVP) Program. My main concern is understanding the process of becoming an MVP and the specific requirements involved. I know the program recognizes exceptional community leaders and experts who share their knowledge and support others, but the actual path to nomination and selection seems a bit unclear. Could anyone share clear guidance on the eligibility criteria, the nomination process, the types of contributions that are most valued, and practical tips to strengthen an application? Your insights and experiences would be highly valuable, not just to me but also to others in the community who may be interested in pursuing this recognition. Thank you so much for your attention and participation.
