office 365
20387 Topicspower query/ dax measure , multiple conditions/ multiple answers
I have loaded multiple tables in power query table of revenue per category: category revenue EM01 86.000 EM02 68.000 EM03 93.000 EM04 87.000 EM05 6.000 EM06 96.000 EM07 87.000 EM08 54.000 table of share per category per accountmanager: employee accountmanager share accountmanager EM01 AM1 75% EM01 AM2 25% EM02 AM1 100% EM03 AM2 100% EM04 AM3 100% EM05 AM2 60% EM05 AM3 40% EM06 AM1 100% EM07 AM1 50% EM07 AM3 50% EM08 AM2 100% Note: in same cases (EM01, EM05, EM07) multiple accountmanagers are in charge for a category. Total of share per category is always 100%. How to organize in power query to connect both tables to get table of revenue per per category per accountmanager? Use measure? Which? Or other solution? Answer (in pivot table) should be: employee AM1 AM2 AM3 total EM01 64.500 21.500 - 86.000 EM02 68.000 - - 68.000 EM03 - 93.000 - 93.000 EM04 - - 87.000 87.000 EM05 - 3.600 2.400 6.000 EM06 96.000 - - 96.000 EM07 43.500 - 43.500 87.000 EM08 - 54.000 - 54.000Solved199Views0likes13CommentsOneDrive, Assignments, and Learning Accelerators are now Generally Available in Microsoft 365 LTI
Enhance your LMS with the power of Microsoft 365 Today, Microsoft is announcing general availability of the OneDrive and Assignments (including Learning Accelerators) experiences as part of Microsoft 365 LTI®—bringing seamless integration of Microsoft 365 tools into learning platforms to simplify workflows and enhance teaching and learning whether you’re using Canvas, Schoology, Brightspace, Blackboard, Moodle or other LMS platforms. Microsoft 365 LTI makes it easier than ever for educators and students to leverage the full suite of Microsoft 365 Education tools within existing workflows. And now, the OneDrive, Assignments and Learning Accelerators (Reading Progress, Speaker Progress and more) experiences previewed in July with the new Microsoft 365 LTI build on all the capabilities of the classic tools and add additional features in one convenient tool. Educators and students benefit from a more seamless and up-to-date LMS experience with Microsoft 365 Education. Teach and learn with confidence knowing that Microsoft 365 LTI is backed by Microsoft's industry-leading security and compliance tools with Microsoft 365 Education. Deploy and access the new Microsoft 365 LTI in your LMS today with the overview and deployment guides. IMPORTANT: If you have deployed the Microsoft 365 LTI previously, you do not need to redeploy in your LMS – however, we do recommend reviewing the deployment guide for any new recommendations or deployment guidance, and revisit your Admin Settings to check your M365 Admin Consent status and review the apps enabled for your educators to have access to in their courses. Classic LTI retirements Microsoft OneDrive LTI, OneNote LTI, Teams Assignments LTI and Reflect LTI are set to retire next September 17, 2026. The Microsoft 365 LTI replaces these separate LTI tools going forward and we encourage you to start proactively migrating your course this term. You will find migration guidance in our admin documentation to help take steps now. We will continue to provide any additional migration guidance as necessary OneDrive and Microsoft 365 files with embedded editors and new placements The new Microsoft 365 LTI tool expands beyond the capabilities of the existing OneDrive LTI tool with capabilities for Word, PowerPoint, and Excel, including Microsoft 365 Copilot - and is now available within your LMS experience by embedding or linking documents, videos, PDFs, and images into course materials like assignments, discussions, modules, announcements and more. Microsoft 365 LTI orchestrates management of permissions to prevent oversharing, and with dedicated course-level storage to support proper document lifecycle management, assignment workflows, and use of Microsoft 365 Copilot. With Canvas, Collaborations are supported along with students editing and submitting Microsoft 365 documents as an external tool assignment without leaving your LMS. This functionality replaces the classic Microsoft OneDrive LTI which will retire September 17, 2026. Learning Accelerators and AI-enhanced assignments available in your LMS - without the requirement for Microsoft Teams With Assignments in Microsoft 365 LTI, you will be able to use Learning Accelerators, multiple-document submissions, AI rubric and instructions generation, AI-assisted feedback, auto-graded Forms and other assignment capabilities directly within your learning management system (LMS), without the need to create and sync a Microsoft Team for your class. Assignments in Microsoft 365 LTI no longer require Teams access, enabling more LMS users to benefit from AI-enhanced experiences that were formerly exclusive to Microsoft Teams for Education. And Assignments can be created, managed, completed, and graded, without leaving your LMS with grades and feedback available to sync automatically to the LMS gradebook. New: Improve student speaking and presenting skills in 13 languages with Speaker Progress Exciting new AI Feedback features for educators to leverage, students can practice for in-class presentations or save class time by presenting and turning in their presentations for grading. This capability is included automatically in the new Microsoft 365 LTI tool. Existing, Teams-based assignments will continue to work and can be copied to new courses, so no migration is necessary. The assignments functionality in Microsoft 365 LTI replaces the classic Teams Assignments which will retire September 17, 2026. Dive into the new Microsoft 365 LTI to streamline your LMS experience We are bringing our Microsoft 365 Education capabilities for learning management systems together into a single, unified tool to streamline the user experience. Educators will be able to access Learning Accelerators, Reflect, OneDrive, Teams, and more in their LMS courses, without having to enable multiple tools separately, and without overcrowding menus where LTI tools surface. Whether adding content to a module, creating an assignment, or scheduling a meeting for a class, you will be able to easily access Microsoft 365 Education related features directly in your LMS workflow. Microsoft 365 LTI is available for supported LMS platforms, including Canvas by Instructure, PowerSchool Schoology Learning, Blackboard by Anthology, D2L/Brightspace, Moodle™, and for any LTI 1.3 Advantage compliant platform. Migration guidance and tools Guidance for migrating users from the classic LTI tools to the Microsoft 365 LTI can be found in our First Time Configuration guide. We strongly recommend guiding users to leverage the new experiences for OneDrive, Assignments, Reflect and OneNote Class Notebooks in the Microsoft 365 LTI as the classic experiences are set to retire on September 17 th , 2026. We are working on additional guidance to help with migration of existing content ahead of classic LTI retirements, and more information will be available soon. Compliance and regulatory resources Visit the Microsoft Service Trust Portal to learn how Microsoft cloud services protect your data, and how you can manage cloud data security and compliance for your organization. You will find our latest HECVAT assessment along with other resources for Microsoft 365 LTI and all Microsoft apps and services. For more information, and to keep up with future product announcements Please visit the Microsoft Tech Community Education Blog and subscribe to keep up with what’s new in Microsoft Education. We also hold bi-monthly office hours every first and third Thursday where lots of LMS + Microsoft 365 customers come to discuss scenarios and get assistance from peers, please join us. Microsoft 365 LTI Office Hours 1 st and 3 rd Thursday of each month at 11am EST Join link: https://aka.ms/LTIOfficeHours How to get help or send feedback For any issues deploying the integration, our Education Support team is here to help. Please visit https://aka.ms/EduSupport Once deployed, there are links to Contact Support and Send Feedback from right within the app. These can be found in the user voice menu in the upper right on any view that appears within the LMS. Learn more about Microsoft feedback for your organization. Learning Tools Interoperability® (LTI®) is a trademark of the 1EdTech Consortium, Inc. (1edtech.org) The word Moodle and associated Moodle logos are trademarks or registered trademarks of Moodle Pty Ltd or its related affiliates.185Views0likes0CommentsAI-powered Teach Module in M365 now rolled out to all educators!
Here is an end-to-end tutorial video on the new AI-powered "Teach" module in M365 Copilot. This is available today for ALL Microsoft 365 educators globally! Includes: 📘 Lesson plans 📊 Rubrics 📝 Quizzes 🌍 Standards grounding (35 countries) 🎯 Learning Activities ➕ Lots more YouTube 📺 https://youtu.be/WkXVukl62KU?si=UT3FzN5fqXQ7KlBd11Views1like0Commentsi need the data from all the sheets in the workbook to link to one data sheet.
A colleague of mine made a data spreadsheet (lets call it SHEET 1), he no longer works for the company and over time the worksheet has been amended, so doesn't work like it should. There are several sheets in the workbook and all data that is copied into these needs to go into SHEET 1 (doing it itself, not manually). My question is when I download my data and paste into SHEET 2, how do I get it to automatically go on to the SHEET 1, taking only certain parts of the data, in this case B and F. The attached is just a small example of the data I need from SHEET 2. On SHEET 1 There is a list of numbers on the left and more, how can I get this data to filter itself onto SHEET 1 in the right column then adding the numbers on the left together. So, on SHEET 1, 160 -T will show 7 because there is 7 1's below for that Org. Sorry if i have made this sound long winded, I am awful at explaining. I have basic knowledge of excel but I cannot get my head around formulas. It should look something like this. Any advice would be great. Thanks13Views0likes0CommentsFilter function with Time criteria
Dear Experts, I have a data like below:- For a Single rnti== 17975(say), and in Column No B is the time-difference between each rows for this rnti, for lcid==4 (column=F) I want to populate Column H~K in a way that if the "isStatusReportRequested_" between 0~5ms then "YES" will be populated in Column "H", and so on Attached is the Worksheet, I tried using IF, but not seems this didn't worked:- Attached is the Worksheet. Br, AnupamSolved53Views0likes3CommentsSheet View Issues with Excel Web Browser
Hi, I have created a Excel document for my department to use, I tried Excel App but due to the size of the Spreadsheet it kept freezing, as a result I switched it to use Excel through Web Browser. The sheet no longer freezes which is good. I do have another issue though.....I wanted multiple users to be able to access, edit the sheet at the same time so I did some research and Sheet View seemed to be the way forward. I created a Sheet view for each employee to use so when you go to View, Sheet View and click on the relevant person their work is updated, saved etc and this shouldn't affect others view. This is working in terms of people editing. The main issue now though is that despite following advice sometimes when someone changes a filter on their own sheet view it seems to change others view. My understanding was you can hide, filter etc within your own Sheet view but this doesn't seem to be the case.......PLEASE HELP!!!! My excel and computer Skills aren't excellent to please any simple advise would be great.64Views0likes2CommentsAllowing External Access
Hi guys, I want to allow guest external access for the folder. I followed the guide and video posted by Microsoft: https://learn.microsoft.com/en-us/microsoft-365/solutions/collaborate-on-documents?view=o365-worldwide I changed the setting in the SharePoint settings, in the identity settings, and I even changed the default permission from edit to view. The only change that went through is the default permission. When I go to my OneDrive and share something, the default is now view; however, I still can't share anything outside my organisation. Can anyone help me find out why? Does it take time for the settings to be pushed? Hope someone can help me.32Views0likes1Comment