Calculating hours using pivot table
Hi, I'm making a personell planning sheet and I want to calculate the sum of hours teachers give lessons. I have 2 tables and my data is formatted like this (simplified) Lesson name Hours Teacher 1 Teacher 2 Lesson 1 2 Paul Lesson 2 3 Pete Lesson 3 2 Paul Pete Teacher name Max working hours Paul 10 Pete 15 Now I want to create an overview of how many hours each teacher is teaching using a pivot table. This is easy when there is just one Teachter collumn but I need to calculate the sum using both teacher collumns... I need to overview to be something like this: Paul -> Lesson 1 + Lesson 3 = 4 hours Pete -> Lesson 2 + lessen 3 = 5 hours Then the next step is to use a metric or KPI to calculate if each teacher is exceeding their max working hours... Can anybody hlelp me with these problems? Thanks!How to Join Microsoft Tech Community & Leina Future Data & AI Hub (Step-by-Step Guide) - Arabic
This session provides a step-by-step walkthrough on how to officially join the Microsoft Tech Community and become a member of the Leina Future Data & AI Hub – Microsoft User Group. The event is designed to help learners, trainers, and data professionals understand: • How to create and verify a Microsoft Tech Community profile • How to join an official Microsoft User Group • How community membership supports learning, networking, and professional growth • How participants can access recorded sessions, resources, and future events This session supports community enablement and knowledge sharing within the Microsoft ecosystem, with a focus on Data, AI, Power BI, and Microsoft Fabric learners. Target Audience: • Students and fresh graduates • Data analysts and Excel/Power BI learners • Trainers and professionals interested in Microsoft communities Session Format: • Recorded session • Practical walkthrough • Community-focused learning Speaker / Host Dr. Leina Nazar Abdelgalil Microsoft Certified Trainer (MCT) Founder – Leina Future Data & AI Hub
PivotBy or GroupBy
Dear Experts, Quick question, I have a data like this from Column A~F, and want to make a data like in Col J~L So, I want a summary , that for the slot0 && txnum==1, what are the unique values of numOfPrb, but in case of slot5, we have more than one unique value and it spills, could you please suggest a solution for this, I tried Filter function etc.. may be there's solution within , or if Groupby or Pivotby can help here. Attached is the worksheet, Br, AnupamHow to write a script or any PQ or in Excel to download the zip files from a Webpage
Dear Experts, Greetings! https://www.etsi.org/deliver/etsi_ts/138300_138399/138306/ Could you please help me on how to download the pdf.zip files from above for all the versions? Using a single command in Excel or PQ-option. Thanks in Advance, Br, AnupamThis week's Fabric Engineering Connection calls - Holiday Cheer Edition
🎉 Holiday Cheer Alert! 🎶 Ready to jingle all the way with the Fabric Partner Community? Join us for our Fabric Engineering Connection - Holiday Cheer Edition! The festivities kick off with a “Name That Tune: Holiday Edition” game—where your competitive spirit could win you fabulous prizes! Bring your brightest “Ho Ho Ho,” your silliest sparkle, and get ready to sleigh the season with us. 🎅✨ Stick around for inspiring presentations from our guest speakers: 🦌Nellie Gustafsson, Principal PM Manager, with updates on Data Science, AI, and Data Agents (Americas & EMEA call only) 🦌Shireen Bahadur, Senior Program Manager, and Ajay Jagannathan, Principal Group PM Manager, sharing “What’s New in Database Mirroring” 📅 Americas & EMEA: Wednesday, December 17, 8–9 am PT 📅 APAC: Thursday, December 18, 1–2 am UTC Show starts on the hour—enthusiasm mandatory, jingle optional! 🔔 To join, become a member of the Fabric Partner Community Teams Channel (if you are not already): https://lnkd.in/g_PRdfjt Let’s deck the halls, spread some cheer, and make this celebration one to remember!
In a Day (xIAD) Partner Events Program - Train the Trainer Events (DIAD/FAIAD/RTIAD/CWYDIAD)
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. *Please note, participation is restricted to individuals representing a Microsoft Partner organization. You must register using your corporate email address that is associated with your Partner ID. Personal emails will not be approved. ✨ 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. Currently available on-demand. Inquire at xiadevents@microsoft.com 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. Currently available on-demand. Inquire at mailto:xiadevents@microsoft.com Chat with your Data in a Day This is an intermediate-level training designed for Power BI data analysts and developers to help get their models chat-ready and unlock instant insights using natural language. December 22, 2025 - EMEA 9-5 CEST December 23, 2025 - AMERICAS 9-5 CST Sign up at https://aka.ms/CWYDIAD-ttt 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
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 partner that is interested in data and analytics? After a two-week break for Ignite and Thanksgiving, be sure to join us for this week's Fabric Engineering Connection calls! Yitzhak Kesselman will be presenting on the brand-new Microsoft Fabric IQ, just announced during Ignite, followed by Shuaijun Ye with Environment Best Practices. The Americas & EMEA call will take place Wednesday, December 3, from 8-9 am PT and the APAC call is Thursday, December 4, from 1-2 am UTC/Wednesday, December 3, from 5-6 pm PT. This is your opportunity to learn more, ask questions, and provide feedback. To participate in 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 at the calls!
