admin
6659 TopicsCreate a Power query or Dax to find Open Status more than 1 hour
Hi Team, I have the door table Here I want to find that whether door is being open continuously(having open status & not closed) for more than 1 hour for each DeviceId. Data Description: The Status column shows whether door is open or Closed. CreatedOn column shows time duration. DeviceId column shows Deviceid. My first requirement is: We need to add the minutes(createdon) between each row for same deviceid where the status = open. But where a status = closed (if closed comes in between open) we reset the number of minutes. So we sum by the previous value where status = Open - Something like If current status = open and previous status = open then sum the time and do the below: Sum(previous value + new sum) Where/if status = closed set time count = 0 Sum(previous value + new sum) is going to take into account only the consecutive open status >60 min for same divice id whenever status is closed, this Sum(previous value + new sum) will be reset to/equal to 0 So on the first open status, the count will be 0. Then the next open status it will be time between 2 open statuses, then on the third it will be the time between two open statuses add the previous time.but any close status then time is reset. Could you please help me with a power query logic/dax logic? Second Requirement: This is only a sample data. But we have billions of rows of data in our dataflow that comes from SQL views. So, thought not to use DAX for this calculation in future. we can precalculate the maximum open state duration by preprocessing data (SQL, Power Query(dataflow), Spark, anything else...). So can you help me prepare data upfront. we need to solve the problem with a with a proper data model. for example, create a table with the longest open events upfront (in whatever technique you are comfortable with) Could you please help me to achieve this? PFA file here B&M.pbix Thanks in advance!75Views0likes7CommentsSharepoint central IT management best practices
Hi, At my company, we would like to use our corporate SPO infra more and more to diminish our local storage needs and foster collaboration but the problem is that we are having a huge sprawl and we don't have any control of what is being published like confidential stuff, documents with personal data in them, DBs etc. Is there a paper with Central IT SPO management best practices that can help us controlling/avoiding this type of situations? Thanks/Brgds jc7Views0likes0CommentsDax to find open status for more than 1 hour
Hi Team, I have the below table: Here I want to find that whether door is being open for more than 1 hour or not. The Status column shows whether door is open or not. CreatedOn column shows time duration. Could you please help me create a dax logic to achieve this? PFA file here B&M.pbix Thanks in advance! SergeiBaklanSolved69Views0likes5CommentsClipchamp’s brand kit: simplifying consistent video creation for organizations
Empowering our users to tell stories worth sharing lies at the heart of what we do at Clipchamp, and in a world increasingly focused on enterprise narratives, it’s become clear that these stories are often needed to help communicate the ethos of a brand. That’s why we’re excited to share more about our refreshed brand kit feature, designed to improve organizational branding capabilities within our video editor. With this update you now can organize a comprehensive collection of video elements—like logos, colors, and fonts—into a brand kit, for your teams and organizations to apply to any video. Whether it's an internal team meeting recording or a ‘how-to' video showcasing new product features, users and organizations can easily ensure that their brand identity is represented correctly, every time. Our brand kit empowers admins and brand managers to collate approved assets and share brand kits across global teams, ensuring that visual standards are consistent across the board, and across the world. GIF of Microsoft Clipchamp Brand kit and the branded elements it supports This ability to ensure that assets are uniform means that consistent content is now achievable at scale, helping to bolster the clarity of messaging for large enterprises, while leveraging a familiar and easy-to-use interface that doesn’t require extensive video editing experience. The flexibility and ease of uploading branding elements to your brand kit means that you can ensure not only the clarity of the message, but also its aesthetic and creative presentation with images, music, graphics and more. By the end of March 2025, brand managers and admins will be able to leverage template generation as well, allowing their teams to create foundational branded projects that can be easily replicated, modified, and reused. Brand consistency across your organization Organizations in today’s digital-first world understand the critical importance of consistent messaging and visuals in maintaining a cohesive brand narrative, for both internal and external communications. With Clipchamp's brand kit feature, ensuring uniformity of content is now easier than ever. "Knowing that all our content is aligned with our brand guidelines - whether it's the logo, fonts, colors, or even the music - gives us total confidence in the product. It saves time and helps every team member, no matter their design skills, to produce professional, on-brand videos." Paul Burke, Head of Global Brand at Amadeus. Once set up, your brand kit integrates directly into Clipchamp, appearing by default for all users in your organization. This eliminates the need for manual uploads or version control headaches. To get started, here are the steps below. If you want a deeper dive into creating and sharing brand kits across your organization, check out more details here 1. Select an existing SharePoint site or create a new site to host the brand kits This can be any type of site, such as a communication site, a team site that's connected to a Microsoft 365 Group, or a modern team site that isn't connected to a Microsoft 365 Group. Then, add the people you want to be able to upload files as members or owners of the site or Microsoft 365 Group. 2. Use PowerShell to designate the document library as org asset type BrandKitLibrary Ensure you have SharePoint PowerShell client versions >= 24830.12754 or download the most recent. Run the cmdlets in a PowerShell terminal. Connect-SPOService -Url https://yourorg-admin.sharepoint.com/ -Credential admin@yourorg.onmicrosoft.com (The parameter -Url points to the admin site.) Configure the new Document Library as Org Asset Type: BrandKitLibrary Add-SPOOrgAssetsLibrary -OrgAssetType BrandKitLibrary -LibraryUrl https://yourorg.sharepoint.com/sites/BrandGuide/brandkit In the above example "BrandGuide" is the SharePoint site and "brandkit" is the document library name. 3. Create a brand kit and add media within Clipchamp Select the 'Brand kit' section in the left side panel and select 'Create brand kit'. Choose the folder you designated as a BrandKitLibrary in the previous step. You may wish to share the brand kit to collaborate with colleagues on populating assets. To share the brand kit while preparing it, select "Share brand kit". Provide recipients with the link and ensure they have edit access. Sharing consistent assets across different locations ensures that every video being shared looks on-brand and reinforces brand recognition, no matter where it’s seen. Plus, we’ve made sharing brand kits simple by using familiar OneDrive patterns. That way, users don’t have to interact with unfamiliar technologies—just seamless access to everything you need, so you can stay focused on creating professional, polished content. Add a wide range of your media assets A screenshot of a video editing project in Clipchamp, with the brand kit panel open The brand kit feature in Clipchamp allows for a broad range of assets to be uploaded, ensuring that users can express their brand narrative through a variety of media. Clipchamp supports an array of branding elements, including logos, colors, fonts, images videos, graphics, music, and sound effects. A screenshot of a video editing project in Clipchamp, with the brand kit panel open. The cursor hovers over the 'Add colors' section, while logos, fonts, and images are also displayed There is a strong case for adding branded elements to enterprise content: it helps to easily generate a strong brand identity, while building trust with your audience, and maintaining a professional lens on content production. Clipchamp also allows users to upload multiple branding options, so you can add your primary and secondary color palettes, or light and dark design schemes. Feedback We are so excited to bring users some new additions to brand kit and would love to hear feedback around the organizational sharing experiences. Please head to this link to share with us your insights or feedback, so we can continue to create the best possible experiences for our users.352Views2likes1CommentRandom Exchange Server to 365 migration batch fails with the error "SourceMailboxAlreadyBeingMoved"
I'm running a migration for a small customer (about 400 mailboxes). half of the mailboxes are migrated just a couple of random mailboxes failed with this error. Has anyone faced/worked around this issue? I've tried following with no success: -Tried after a server restart -Tried creating a new batch ---- Error ---------------------------------------------------------------- Data migrated: 46.29 MB (48,542,751 bytes) Migration rate: Error: SourceMailboxAlreadyBeingMovedPermanentException: Couldn't switch the mailbox into Sync Source mode. This could be because of one of the following reasons: Another administrator is currently moving the mailbox. The mailbox is locked. The Microsoft Exchange Mailbox Replication service (MRS) doesn't have the correct permissions. Network errors are preventing MRS from cleanly closing its session with the Mailbox server. If this is the case, MRS may continue to encounter this error for up to 2 hours - this duration is controlled by the TCP KeepAlive settings on the Mailbox server. Wait for the mailbox to be released before attempting to move this mailbox again. --> -->244Views0likes2CommentsWhat causes an excel file to 'Show Print Preview' rather than show the preview by default.
I am curious what causes this to happen, I have already set the print area etc., but for some reason I don't get an immediate preview when going to print, I have to click this button inside the print preview. (I have also attached the full screenshot Doesn't seem to matter what settings I change so far, just curious what exactly causes this change in excel, I have many other documents that just bring up the preview straight away when going to print, but at the moment, this one particular file I have to click another button. I have a MS flow that converts excel files to pdf automatically after a review process, but it keeps failing on this one file and I can't figure out why, but I think the key revolves around this, so I really want to find out what causes excel to present an additional button that you have to click to generate a preview rather than showing the preview off the bat like it does with every other file which works fine in the flow. ThankyouSolved77Views0likes5Comments"OVERWRITE EXISTING CELLS WITH NEW DATA..." GET DESELECTED
HELLO , I HAVE OFFICE 365 . FROM 1 MONTH AGO THE BUTTON IN DATA TAB THEN PROPERTIES AND IN IT "OVERWRITE EXISTING CELLS WITH NEW DATA..." GET DESELCTED AUTOMATICALLY AND WHEN WE REFRESH DATA IT GET OVERLAPPED . EARLIER IT WAS WORKING FINE LIKE IN SCREEN SHOT WE HAD SELECTED "OVERWRITE........" TAB BUT WHEN WE PRESS OK AND REOPEN IT IT GET DESELECTED PLEASE HELP ON THIS65Views0likes3Commentsowners vs site owners vs members vs site members vs access to site content
I'm fairly new to SharePoint administrations and have been trying to wrap my head around permissions... Can someone explain to me the difference between owners and site owners as in the screenshot below, and how it relates to access to the site? I found this article (Admin center site permissions reference - SharePoint in Microsoft 365 | Microsoft Learn) but there must be something more to it. I've removed someone from the "Owners" group but kept this same person in three other groups where she was present: "Site owners", "Members" and "Site Members". After I removed this person from the "Owners" group, this person lost access to a document library folder. The document library in question has restricted access with a number of people being granted access nominally. I don't know if this person was in the list or if, being an "Owner" and "Site owner", the access was granted automatically. Nevertheless, re-introducing this person as an "Owner" was not enough and I had to grant her access nominally to that restricted document library. So I don't understand why (1) removing from "Owner" (even kepping her in all other groups) made her lose access and (2) why I had to grant access nominally (being an "Owner" and "Site owner" was not enough)? Any ideas? Thanks, Alex6.6KViews0likes2Comments