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 somehow
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.Filter Function or any Other Logic
Dear Experts, I have a data like this in the Home-Tab:- in the Output file, I need something like this:- So, each rnti's can have duplicated Status PDU, by duplicated means two Status PDU for the same rnti Sequentially using the same "rlcCtrlAckSn_" So , in the Output for each rnti, we need the Count of the spdu-1,spdu-2..... How the spdu calculated? For say Rnti== 384, if we have Status_PDU on the same rnti and same rlcCtrlAckSn( here 1338 say) just after another( sequentially) then it's spdu-1, if it's using the same rlcCtrlAckSn twice, then it's spdu-2, need to populate the counts of each spdu-x per rnti in the Output. Attached is the Worksheet. Thanks & Regards Anupam Shrivastava
Building relationships in data model to leverage power pivot - circumventing unique key ID issue
When building relationships between two data tables in the data model of excel, you require a unique ID / key to relate the two datasets. This makes sense but I find it has an issue: It requires you to reduce the entirety of your dataset down to unique ID's in one of your tables so that it can do the 'one to many' relationship build. If you don't have unique ID's / key, the relationship between two tables often doesn't work. Yes you can use an intermediary table with unique ID's to link the two complete tables, but when using that intermediary table I find you are limited in what additional data rows you can bring into the combined power pivot table to provide context to the relationship. Once you start bringing in contextual rows from the separate tables, there ends up being a lot of repeated values for any numerical figure from the other table, which you are trying to aggregate. An example below of the power pivot table result (data from table 1 in blue, from table 2 in green) Product ID (Unique Key) Service Line Sales Amount COGS 169AKY T Shirts $1,000 $7,500 169AKY Sweaters $2,000 $7,500 169AKY Socks $3,000 $7,500 169AKY Turtle necks $4,000 $7,500 169AKY Pants $5,000 $7,500 COGS from table 2 also has the data broken out by Service Line (T-shirts, Sweaters, etc.), but will only show an aggregate COGS value for all service lines for each unique product ID, instead of breaking it out by Service Line. This is because the Service Line column is being inserted into the power pivot table from table 1, it breaks out sales by Service Line. If you insert the Service Line data column into the power pivot from table 2, COGS would be broken out by Service Line, and only an aggregate for sales would be produced. Ideally the power pivot would display sales AND COGS broken out by Service Line (and Product ID). Is there a best practice for building relationships (unique ID's) between data tables: Without reducing the richness / variety of columns and data in your original tables (when creating the unique ID)? Maybe 'group by' function in power query to obtain unique ID's before building the relationship? With retaining the ability to slice and dice the data by different characteristics (assuming they are present in both source tables) and have that detail presented in the power pivot. Thanks for the help! The humble ApprenticeJoin the Fabric Partner Community for this Week's Fabric Engineering Connection calls!
Are you a Microsoft partners that is interested in data and analytics? Be sure to join us for the next Fabric Engineering Connection calls! š The Americas & EMEA call will take place Wednesday, October 22, from 8-9 am PT and will feature presentations from Teddy Bercovitz and Gerd Saurer on Fabric Extend Workload Developer Kit, followed by a presentation on Data Protection Capabilities from Yael Biss. The APAC call is Thursday, October 23, from 1-2 am UTC/Wednesday, October 2, from 5-6 pm PT. Tamer Farag, Trilok Rajesh and Shreya Ghosh will be presenting on Modernizing Legacy Analytics & BI Platforms. This is your opportunity to learn more, ask questions, and provide feedback. To join the call, you must be a member of the Fabric Partner Community Teams channel. To join, complete the participation form at https://aka.ms/JoinFabricPartnerCommunity. We look forward to seeing you later this week!
Microsoft In a Day (XIAD) Partner Events Program - Train the Trainer Events (DIAD/FAIAD/RTIAD)
We invite you to attend an upcoming Train the Trainer session for Microsoft Partners to learn more about the Microsoft In a Day (XIAD) Partner Events Programand how to lead workshops that empower customers to use and adopt Microsoft products. Our Train the Trainer events are designed to provide you with the knowledge and tools necessary to deliver successful Microsoft In a Day (XIAD) sessions. āØ Why Attend? Expert Guidance: Learn from experienced trainers and get your questions answered. Comprehensive Resources: Access all the content and support you need to succeed. š Upcoming Events: Dashboard in a Day This is a one-day, hands-on workshop for business analysts, covering the breadth of Power BI capabilities. Currently available on-demand. Inquire at xiadevents@microsoft.com Fabric Analyst in a Day This is an intermediate-level training designed for Power BI Data Analysts who have at least one year of experience on Power BI but are new to Microsoft Fabric. November 13, 2025 (EMEA) 9:00 - 12:00 Central European Time - link November 14, 2025 (Americas) 9:00 - 12:00 Central Time - link Real-Time Intelligence in a Day This is an intermediate-level training designed for Power BI developers looking to extract insights and visualize streaming and time sensitive data. November 13, 2025 (EMEA) 1:00 - 4:00 Central European Time - link November 14, 2025 (Americas) 1:00 - 4:00 Central Time - link Once registered, look for your registration confirmation email from notification@msftevents.microsoft.com that contains your unique Teams meeting link to join the virtual event. Be sure to check spam and junk folders, and mark as a safe sender. If you are unable to locate your registration confirmation, email pappspartnerevents@microsoft.com. We look forward to seeing you at an upcoming event! Partner with us! Are you a Microsoft Partner interested in the opportunity to join the program and deliver Microsoft In a Day (XIAD) events? š Learn more about the program and review partner eligibility criteria: https://aka.ms/xiadpartneropportunity. š§ Contact the XIAD Program team: xiadevents@microsoft.com š¤ Submit requests to deliver events: https://aka.ms/xIAD/PartnerEvents
