Power Query - How Do I Count a Number of Entries Based on Another Column?
Hello! The title might be a little confusing. Here's the situation. I manage uniforms for my team. I am making a SharePoint list and form that an employee will use to request the uniforms. Then, to give me a digestible table that shows me exactly what I need, I have an Excel Power Query pulling the list in. On the form, instead of having a different entry for each polo in each color, each size, and each cut, I have it separated so that you pick cut, sizing, and color separately. Is there a way to have Power Query pull it to show me, for the screenshot example: Female L Red Polo: 2 Female L Blue Polo: 2 Male M Red Polo: 3 Male M Blue Polo: 1 Male M Tan Polo: 2 So on, and so forth. Is this possible? Thank you!đ¤ Save the Date: AMA with the Microsoft Fabric Leadership Team!
Weâre excited to announce an upcoming Ask Me Anything (AMA) session with the Fabric Leadership Teamâa unique opportunity for partners to engage directly with the leaders shaping the future of Microsoft Fabric! đš Featured Leader Bogdan Crivat, Corporate Vice President, Azure Data Analytics đď¸ Date & Time Tuesday, February 17 8:00â9:00 AM PT đŹ Ask Your Questions Have topics you want the leadership team to address? Submit or upvote your data analyticsârelated questions now: đ https://aka.ms/AMAwithFabricLT đĽ Who Can Join? This AMA is exclusive to members of the Fabric Partner Community. If you're not yet a member, join here to participate in future calls: đ https://aka.ms/JoinFabricPartnerCommunityđ FabCon + SQLCon Partner Social Sprint
A 4âDay LinkedIn Challenge for Partners Attending FabCon + SQLCon in Atlanta If youâre joining us in Atlanta this March for FabCon + SQLCon 2026, weâve got a new way for you to amplify your impact: the Partner Social Sprint â a daily LinkedIn challenge designed to spotlight partner voices, share realâworld insights, and have some fun along the way. Whether youâre presenting, staffing a booth, or attending sessions, this is your chance to tell your story and connect with the global Microsoft Fabric & SQL community. đĽ What Is the Partner Social Sprint? A 4âday LinkedIn posting challenge running during FabCon + SQLCon 2026 in Atlanta. Each day has a theme, and every post earns you entries to win exclusive Fabric SWAG, including the fanâfavorite Fabric Kicks. đ Daily Themes (Conference Week) Tuesday, March 17 â Day 0 (Travel / Partner Day) Why Iâm going / why Iâm here Wednesday, March 18 â Day 1 One big learning Thursday, March 19 â Day 2 Build your practice Friday, March 20 â Day 3 Customer impact â How It Works If youâre a partner attending FabCon + SQLCon in Atlanta: Post once per day on LinkedIn during the event, following the daily theme. Use the hashtags: #FabConSQLCon2026 #PartnerSocialSprintSweepstakes #MicrosoftPartner Tag the FabCon & SQLCon â The Microsoft Fabric & SQL Community Conferences LinkedIn page. Submit all your LinkedIn post URLs via the entry form. đ Each post = 1 entry, and if you post all 4 days, youâll get 1 bonus entry. đ What You Can Win Fabric SWAG Fabric Kicks Recognition in the Fabric Partner Community and across our channels đ Who Should Join? Microsoft partners attending FabCon + SQLCon in Atlanta Partner sellers, architects, engineers, and community champions who want to: Share key learnings in real time Highlight their Fabric & SQL practices Showcase customer success and impact đ Ready to Sprint With Us? Get all the details and submit your posts here: https://aka.ms/PartnerSocialSprint Letâs light up LinkedIn with the stories, insights, and innovation coming out of FabCon + SQLCon. We canât wait to see your posts from Atlanta!
Help needed with IF and COUNTIFS Formulas
Is anyone able to advise the following formula: =COUNTIFS($B$5:$B$15,$R$4,$C5:$C15,"<=" & V3,$D5:$D15, ">" & V3)-COUNTIFS($B$5:$B$15,"="&$R$4,$G5:$G15,"<=" & V3,$H5:$H15, ">" & V3)-COUNTIFS($B$5:$B$15,"="&$R$4,$K5:$K15,"<=" & V3,$L5:$L15, ">" & V3)-COUNTIFS($B$5:$B$15,"="&$R$4,$O5:$O15,"<=" & V3,$P5:$P15, ">" & V3) Is there a way to simplify this? Is there a way to make this more accurate? Cells in column G & H, I & J, O & P are using the following format: =IF(C6="","",C6+E6) Cells in U4:CC4 are using the following format: =COUNTIFS($B$5:$B$15,$R$4,$C5:$C15,"<=" & U3,$D5:$D15, ">" & U3)-COUNTIFS($B$5:$B$15,"="&$R$4,$G5:$G15,"<=" & U3,$H5:$H15, ">" & U3)-COUNTIFS($B$5:$B$15,"="&$R$4,$K5:$K15,"<=" & U3,$L5:$L15, ">" & U3)-COUNTIFS($B$5:$B$15,"="&$R$4,$O5:$O15,"<=" & U3,$P5:$P15, ">" & U3) Cells in U5:CC15 are using the following format: =IF(U$4>=$T5,1,"") My issue is is when I put in the three break times, the mid break comes out at a shorter time. My other issue is is that when I put in the times in row 5,6and 11, the data is coming up as a combined data in rows 5, 6 and seven on the page two. Just for reference, "page two" is the same spreadsheet. What I need to happen is that I enter in the shift start time and finish time. This then populates through to Break 1, 2 and 3. The Time entry is the time the break starts. ie: 1 hour after start of shift, 1 hour after coming back from break, etc. The break entry is the duration of the break taken. ie: 30 minutes. Once all the info is put in, the relevant "Time Block" on "Page 2" shows a 1. What is happening at the moment is that when I enter all the time data, the time blocks are not populating correctly in accordance to the entry. Basically, If I have numerous people on shiftI need the time blocks to show where I have shortfalls in shift cover and not having too many people on break at the same time. IE: Link to Live Copy: https://www.dropbox.com/scl/fi/eur1j526htu1j8a4d4290/Staff-Breaks.xlsx?rlkey=r4tm9xts4tonofpa2th2cusfw&st=nueyk0d7&dl=0 Any ideas would be greatly appreciated.Join the Fabric Partner Community for this Week's Fabric Engineering Connection calls!
The Fabric partner ecosystem is buzzing right now â and 2026 is already raising the bar. đ On this week's Fabric Engineering Connection call, Tamer Farag will share whatâs next for partners across skilling, demos, FabCon + SQLCon Atlanta, and more. Highlights include: đ More skilling momentum (DPâ600/DPâ700 vouchers, new Partner Project Ready workshops, and a new âChat with your Data in a Dayâ xIAD workshop). đŚ Fabric Certification Spotlight: partners who reach 100+ Fabric certifications will be recognized live in Arunâs keynote at FabCon + SQLCon. đ¤ New ways to tell your story and win with customers through Fabric Demo eXperiences, Fabric Featured Partners + case studies, and FabCon experiences (Partner Elevator Pitch Search, 1:1 + executive meetings, testimonial videos, the Partner Social Sprint, and more). If youâre a Microsoft partner investing in Fabric, weâd love for you to join our next Fabric Engineering Connection call: đ Americas/EMEA â Wednesday, Feb 4, 8â9 AM PT đ APAC â Thursday, Feb 5, 1â2 AM UTC (Wednesday, Feb 4, 5â6 PM PT) To join, you must be a member of the Fabric Partner Community in Teams: https://aka.ms/JoinFabricPartnerCommunityQuarterly AMA with Amir Netz â Microsoft Fabric Partners, Donât Miss Out!
đ Microsoft Partnersâdonât miss your chance to connect directly with Amir Netz, CTO & Technical Fellow, at our exclusive Quarterly AMA (Ask Me Anything) session! The Fabric Engineering Connection is your gateway to insider insights, direct access to product leaders, and the latest updates on Microsoft Fabric. As a valued partner, youâll have the opportunity to ask questions, share feedback, and learn about new features and strategies that can help you drive success for your clients and your business. This session is designed to empower partners with actionable knowledge and networking opportunities. đ Save the date: Americas & EMEA: Wednesday, January 21, 8â9 am PT APAC: Thursday, January 22, 1â2 am UTC / Americas & EMEA: Wednesday, January 21, 5â6 pm PT đ Not a member yet? Join the Fabric Partner Community to participate: https://aka.ms/JoinFabricPartnerCommunity. Letâs build the future of data together!Join the Fabric Partner Community for this Week's Fabric Engineering Connection calls!
đ Upcoming Fabric Engineering Connection Call â Americas & EMEA & APAC! Join us on Wednesday, January 14, 8â9 am PT (Americas & EMEA) and Thursday, January 15, 1â2 am UTC (APAC) for a special session featuring the latest Power BI Updates & Announcements from Ignite with Sujata Narayana, Rui Romano, and other members of the Power BI Product Team. Plus, hear from Tom Peplow on Developing Apps on OneLake APIs. đ 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 learn, connect, and stay up to date with the latest in Microsoft Fabric and Power BI!
In a Day (xIAD) Partner Events Program - Train the Trainer Events (DIAD/FAIAD/RTIAD/CDIAD)
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. February 19th, 2026 - Americas - CST time zone. Sign up at https://aka.ms/TTTSignUp 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. February 19th, 2026 - Americas - CST time zone. Sign up at https://aka.ms/TTTSignUp 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. February 19th, 2026 - Americas - CST time zone. Sign up at https://aka.ms/TTTSignUp 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. Chat with Your Data in a Day - Americas - Jan 23 Chat with Your Data in a Day - APAC - Jan 28 Chat with Your Data in a Day - EMEA - Feb 17 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
