Adding Data Points to a Table or Chart After Power Query Refresh
I have an Excel workbook that has a worksheet for calculating who doesn't have access to our system based on content on the site. These calculations use XLOOKUP to compare two other workbooks (1 CSV and 1 XLSX). I then have Power Query clean up that sheet to generate a report. The CSV and XLSX are also cleaned up with Power Query prior to the calculations taking place. The output of the final report looks like this: I would like to know the total count of people, the unique count of people, the number of people who are the sole owners, the number of people who are listed with other people who do have access. As you can see behind the blur under "Triggered Owner", there can sometimes be more than one. The tricky part here is that I would like to track these numbers in a new row in a table for each refresh, similar to the below, where the data doesn't completely erase each time. Run Date is when the refresh occurs. Is this possible?
access to bookings
What does this message mean on microsoft booking, ive been trying to see my booking registry but i keep seeing this message, sometimes the massage varies when i try to access the app : Detailed message displayed: UTC Date: 2025-03-11T14:14:30.266Z Client Id: F6F199305D9541EDA2A53EE57C90EDB8 Session Id: 8009806d-b6f3-40b9-9ddd-0ef7ba2b900f Client Version: 20250310070 BootResult: network Back Filled Errors: Unhandled Rejection: Error: [object Object]:undefined|Unhandled Rejection: Error: [object Object]:undefined|undefined:undefined|undefined:undefined err: Error: [object Object] esrc: StartupData et: ServerError estack: Error: [object Object] at https://res.df.onecdn.static.microsoft/owamail/hashed-v1/scripts/owa.47106.6187e72c.js:1:71227 at async S (https://res.df.onecdn.static.microsoft/owamail/hashed-v1/scripts/owa.10245.3a6876a0.js:1:3108) at async https://res.df.onecdn.static.microsoft/owamail/hashed-v1/scripts/owa.10245.3a6876a0.js:1:2460 at async l (https://res.df.onecdn.static.microsoft/owamail/hashed-v1/scripts/owa.bookingsindexv2.b6602698.js:1:97492) at async w (https://res.df.onecdn.static.microsoft/owamail/hashed-v1/scripts/owa.bookingsindexv2.b6602698.js:1:100345)
Conditional formatting - new rule based on two related column headings
Need to create a new rule that changes cell colors (column H) based on more than 2 falls (column C) in 30 days for the same person (column A). I've found the formula for just the date - but not for adding in the same name. Goal is to be alerted (visual alert) if someone fell more than 2 times in 30 days. Thanks!
Cubeset with multiple Period range
Hey All! need help with creating a Cubeset formula! I've market data at region level for multiple period & brand! I want to know the rank of particular Brand in each region on Specific Period. Formula is working for a particular period but not working on a range! How can I use a range/dynamic period in cubeset. =CUBESET( "ThisWorkbookDataModel", "EXISTS([Brandmaster].[Brand].children, ([State_Master].[State].[Maharashtra], {[Calendar].[Month].[Oct-2024]:[Calendar].[Month].[Dec-2024]}))", "Set", 2, "{([Measures].[S_Value],[State_Master].[State].[Maharashtra],{[Calendar].[Month].[Oct-2024]})}" ) This is working for particular month but when I want to get data for 3 month like Oct-Dec =CUBESET( "ThisWorkbookDataModel", "EXISTS([Brandmaster].[Brand].children, ([State_Master].[State].[Maharashtra], {[Calendar].[Month].[Oct-2024]:[Calendar].[Month].[Dec-2024]}))", "Set", 2, "{([Measures].[S_Value],[State_Master].[State].[Maharashtra],{[Calendar].[Month].[Oct-2024]:[Calendar].[Month].[dec-2024]})}" ) I'm getting error on this. Range is working on set expression but while using same in Sort By (Highlighted Part), I'm getting the error. One way around is passing Each Month separately not tried that but I want it to be dynamic using timeline & using Min/Max function to define the range, it could be 2month or 12 month. Pls help me with this. Thanks
Issue in Days Function
Hello there, I am Balaji, I hope you are all doing well. I am using Windows 10 in Dell Latitude 7480 Laptop. I am facing an issue using the "Days" Function. DAYS Function Explanation and Description mentioned in Excel Software: DAYS FUNCTION This article describes the formula syntax and usage of the DAYS function in Microsoft Excel. For information about the DAY function, see DAY Function. Description: Returns the number of days between two dates. DAY function This article describes the formula syntax and usage of the DAY function in Microsoft Excel. For information about the DAYS function, see DAYS Function. Description: Returns the day of a date, represented by a serial number. The day is given as an integer ranging from 1 to 31. Now, If I am using the "DAYS" Function to calculate the number of days between two dates. Suggest me Which Function should I use to get the correct answer. I am Looking forward to your guidance. Thank you.
Index & Match formula not working on multiple column
https://onedrive.live.com/personal/8419718c3ad8f98c/_layouts/15/Doc.aspx?resid=8419718C3AD8F98C!s94600d3fa0044d418fefd1508e44c0e2&cid=8419718C3AD8F98C&migratedtospo=true&app=Excel Hi Folks, I'm facing error on the match formula, which I tried to apply, I'm getting #N/A error... I tried few trouble shoots to make it work (adding helper column, broke the formula with "&" to make it work, checking for any additional characters & checking the format etc) but it is not working. I have used Match formula earlier, but never had this issue. I want a single formula to MATCH & verify multiple column to return the desired output, I can do single column verification & again to do the next column verification and get the result but it is tedious and not time saving. Kindly help me to learn how to make a formula work to one validation of multiple column. Kindly attaching the sheet above for reference. Highlighted the error in yellow hue(Sheet name - result). m_tarler & HansVogelaar - Please help, Thanks in advance
Get ISIN Number from Company name and vice versa
I have an Excel sheet with over 300 US companies and their ISIN Numbers listed at the stock market which I have to verify. Is there anyway to get the ISIN Number using the companies name or vice versa. That way I don‘t have to manually google each company and compare the ISIN numbers. Kind Regards.
Microsoft 365 (Word) Paper Sizes
Today, I measured what is supposed to be 8.5" X 11" paper using an online ruler and found that my paper and padfolio sizes do not make sense. For example, my padfolio is actually 8.5'' H X 6.5" W based on the onscreen ruler. The printer paper I have bought states 8.5" X 11" but it is actually 7.5" H X 5 3/4 " W based on the onscreen ruler. Of course, the monitor is at a 100% and is supposedly 32 inches but only maps out to 18 3/4 according to the onscreen ruler. Therefore, I would like to know what the exact paper sizes are for Microsoft 365's 8.5" X 11" paper settings in both the web and desktop version.
