Help, COUNTIFS function
Hi all, Bit of a long one.... I need cell J3, to calculate the value if Column B = "FW1", if Column H = "Amazon", if column p = "Pending or Closed" , and Column W = "1" so far i have got: =COUNTIFS('FW Reg'!B:B,"FW1",'FW Reg'!H:H,"Amazon",'FW Reg'!P:P,({"pending","closed"}),'FW Reg'!W:W,"1") But Excel wont accept it... What am i doing wrong?
KPI dax logic not giving correct counts but table visual does
Hi Team, I have below dax for the Doors open kpi: Doors Open = VAR _count = CALCULATE( MAX( BMSDoorStoreJoin[CreatedOn] ), BMSDoorStoreJoin[Status] = "Open" ) VAR _siteid = MAX(BMSDoorStoreJoin[SiteId]) RETURN CALCULATE( COUNT( BMSDoorStoreJoin[CreatedOn] ), BMSDoorStoreJoin[Status] = "Open"&& BMSDoorStoreJoin[CreatedOn] = _count && BMSDoorStoreJoin[SiteId] = _siteid ) Now, this returns the value of 1 which is wrong according to filtered SiteId(StoreName). My expected output from this logic is I want to find unique count of Doors Open(Site[Sitecode]) for the max of createdon date. For example, the data below for Sitecode 472 we have Status as closed and we don't have open. So it should retun nil. but in this case it returns 1. My table visual also shows correctly that it has only closed status. When i use my kpi logic in that visual it gives correct count. Please advise! PFA file here BMS Chillers Insights.pbix Thanks in advance! SergeiBaklanCreating Logic to find whether columns in one table matches other columns in other table
Hi Team, I have 2 tables: Door table as below: Store Status table as below: They are modelled as below (let me know if we can better model it-suggestions are welcomed): Now, I need to create a logic(Breach) to find when Door Table - Status column being Open when Store Status table - Status column being Closed (indicated by - 'C'). During this logic, we have to make sure it satisfies below conditions: DateTime column of Store Status table should match the createdon column of Door table Store id column of Store Status table should match the siteid of Door table Output should return 1 if the conditions meets else 0. Could you please help me create a logic for this? PFA file here B&M.pbix Thanks in advance! SergeiBaklanUnlock the Future of Secure Authentication: Moving to Keyless Authentication with Managed Identity
Why Managed Identity? Traditional authentication methods often rely on keys, secrets, and passwords that can be easily compromised. Managed identity, on the other hand, provides a secure and seamless way to authenticate without the need for managing credentials. By leveraging managed identity, you can: Reduce the Risk of Compromise: As most security breaches start from identity-related issues, moving to a keyless authentication system significantly reduces the chances of such compromises. Simplify Credential Management: Managed identity eliminates the need for managing keys and secrets, making the authentication process more straightforward and less error-prone. Enhance Security: With managed identity, your applications are granted access to resources securely, without the risk of exposing sensitive credentials. Getting Started with Managed Identity To help you get started with managed identity, Microsoft offers comprehensive training modules for different programming languages. These modules cover the basics of using managed identity to authenticate to Azure OpenAI, providing you with the knowledge and skills needed to implement secure authentication in your applications. Available Microsoft Learn Training Modules: Introduction to using Managed Identity to authenticate to Azure OpenAI with .NET - Training | Microsoft Learn Introduction to Azure OpenAI Managed Identity Authentication with Java - Training | Microsoft Learn Introduction to Azure OpenAI Managed Identity Authentication with Python - Training | Microsoft Learn Introduction to Azure OpenAI Managed Identity Authentication with JavaScript - Training | Microsoft Learn Why Should Students Learn Managed Identity? As a student, learning about managed identity and keyless authentication is not just about enhancing your technical skills; it's about preparing for the future. Here are a few reasons why you should dive into managed identity: Stay Ahead in the Job Market: With cybersecurity being a top priority for organizations, having expertise in secure authentication methods like managed identity will make you a valuable asset to potential employers. Build Secure Applications: By implementing managed identity, you can build applications that are more secure, reliable, and less susceptible to breaches. Understand Modern Security Practices: Gaining knowledge about managed identity and keyless authentication will give you a deeper understanding of modern security practices and how to protect applications in today's digital landscape. Conclusion In conclusion, moving to keyless authentication through managed identity is a game-changer for securing applications. As students and future developers, embracing this technology will not only enhance your skills but also contribute to building a safer and more secure digital world. So, take the first step today by exploring the training modules and mastering the art of managed identity!Mondays at Microsoft | Episode 43
Closing out February 2025 strong! Join Karuana Gatimu and Heather Cook for the next Mondays at Microsoft as they dig into recent product updates, AI innovation, and activities around the globe. Join live, Monday, February 24th, 8:00 AM PT. Links to all resources shared during the live broadcast: Community resources: Download the show reminder on your calendar: https://aka.ms/MondaysAtMicrosoft Mark it! Microsoft Community page on LinkedIn: https://aka.ms/MicrosoftCommunityLinkedIn . Read it! Community News Desk: https://aka.ms/CommunityNewsDesk NOW ON DEMAND | Watch the SharePoint event "From Concept, to Creation, to Impact" + live AMA: https://aka.ms/SharePointEvent with Jeff Teper + the new 5-part learning series + 3 new customer case studies. Majorana 1 - A new quantum chip that is powered by a Topological Core architecture | Listen to Microsoft's recent quantum computing advancements on the Ideas podcast: https://aka.ms/Ideas/QuantumComputing | Qubits FTW! Plus, a great related news: https://www.microsoft.com/en-us/research/podcast/ideas-quantum-computing-redefined-with-chetan-nayak/ "Introducing Muse: Our first generative AI model designed for gameplay ideation" by Katja Hofmann: https://aka.ms/IntroducingMuse. Monthly "byte-sized" updates on Microsoft innovations and global tech advancements: https://aka.ms/MicrosoftMonthlyTech-In "Inclusive Innovation: The role of AI in accessibility and neurodiversity": https://news.microsoft.com/source/asia/features/inclusive-innovation-the-role-of-ai-in-accessibility-and-neurodiversity/ by Anthony Moufarrege "Microsoft at Legalweek: Help safeguard your AI future with Microsoft Purview" by Katerina Athanasiou: https://aka.ms/LegalWeek. "3 ways to improve access to justice through court modernization " by David Williams: https://aka.ms/AccessToJustice. Announcing the 2025 Imagine Cup Semifinalists: https://aka.ms/2025ImagineCup/Semifinalists. Follow Beatris A. Mendez Gandica on LinkedIn — https://linkedin.com/in/beagandica. Beatris started a nonprofit organization, Nuevo Foundation, where she works to prepare underrepresented students to become tomorrow’s leaders. Apply for the Women at Microsoft Scholarship, deadline March 13, 2025: https://aka.ms/WomenAtMicrosoftScholarship. Make a plan to celebrate International Women's Day #IWD2025 #Accelerate Action: https://internationalwomensday.com. FYI... Microsoft 365 Blog: https://aka.ms/M365BlogMM Azure Blog: https://aka.ms/AzureBlogMM Dev Blog: https://aka.ms/DevBlogsMM Power Platform Blog: https://aka.ms/PowerPlatformBlogMM Power Apps Blog: https://aka.ms/powerappsblogMM Microsoft Fabric Blog: https://aka.ms/fabricblogMM Dynamics 365 Blog: https://aka.ms/Dynamics365blogMM SharePoint Hackathon | Design, create, share! We are excited to invite you to a hackathon dedicated to crafting exceptional employee experiences using AI and the latest SharePoint features! Join in: https://aka.ms/SharePoint/Hackathon | Hack submissions open from March 3-17, 2025 "Introducing Azure AI Foundry Labs: A hub for the latest AI research and experiments at Microsoft" by Asha Sharma and Ashley Llorens: https://aka.ms/AIFoundryLabs. "Introducing the SharePoint Pages Authoring Accessibility Assistant " by Tina Chen: https://aka.ms/SharePoint/AccessibilityAssistant. Register now for Power Platform and AI workshops in a city near you: https://aka.ms/KickstarterWorkshops. New training course for digital accessibility skills: https://aka.ms/AccessibilitySkills. Ref. Jenny Lay-Flurrie Announcing the GitHub Copilot Chat, now available for free on GitHub mobile: https://aka.ms/GitHub/Mobile. Follow Microsoft Community LinkedIn: https://aka.ms/MSCommunityLIMM. Community News Desk: https://aka.ms/CommunityNewsDesk. To learn more about the Microsoft Global Community Initiative - a meeting place for all who are part of the Microsoft Community ecosystem, all are welcome: https://aka.ms/MGCI. Level up your Microsoft 365 and #AI skills, chat with product makers, and network with your tech peers. hashtag#M365Con is May 6–8 in Las Vegas (MGM Grand Hotel & Casino Las Vegas) - The ultimate community event filled with keynotes from Jeff Teper, Vasu Jakkal, Jared Spataro, solution-oriented sessions from Microsoft, MVPs and community leaders, workshops to deepen core skills, a vibrant expo hall, and more. Register now, save $150 with code SAVE150 🎟️ https://aka.ms/M365Con25 Heather Cook invites you to M365Con25 #promo: https://www.youtube.com/watch?v=LtPq-1YAZjY Karuana Gatimu invites you to M365Con25 #promo: https://www.youtube.com/watch?v=MGwK47ekYAo Next episode of Mondays at Microsoft: Monday, March 10th at 8am Pacific. Join in! Check out our page for our show and Community Studio efforts at https://aka.ms/MondaysAtMicrosoft.How to..
Hi all, not sure how to explain this. But can someone explain the steps on how to code the text like C & P to automatically apply when typing it in other cells. See example below. I'm looking to have "PM" coded the exact same way as the other letters, where I can type it and it will automatically add the colour as well. Hope that made sense.
