Search results

Hi All, Let me give full context here: I have: A disconnected table called, say, MetricTable, with rows like: # of projects created # of projects completed # of projects Inprogress # of projects Cancelled A smart DAX measure like MetricValue using SWITCH(SELECTEDVALUE(MetricTable[Metric...

Hi All, Context: I am working on process performance comparison dashboard in PowerBI. I have metric measurements for TAT, FTR, Efforts and Iterations. EffortMeasure = ROUND(AVERAGE(ProjectData[Total Actual Efforts]), 1) FTRMeasure = FORMAT(ROUND(DIVIDE(SUM(ProjectData[FTR Yes Tasks count])...

Hi All, I am using a matrix visual on powerbi dashboard. my Final Matrix Layout is as follows: Columns: Baseline_MonthPerf (e.g., PrevBaseline, Month 1, Month 2) Rows: Asset Type Service Type Project Category Request Type Project Complexity (No header, but column with metric names) Values...

Hi All, In my dashboard, I want to add a read-me page. This page will be no calculation or numbers involved. However, will consists of assumptions, formulas used for various metrics in the dashboard, etc. Is there any good visualization or combination of visualization available in PowerBI...

Hi All, I have data of planned and actuals for every team member across different projects in specific format given below. I have also attached the sample workbook. Planned Actuals Planned Actuals Planned Actuals Planned Actuals Planned Actuals Planned Actuals Team Members Project1...

I was trying to get some help with number formatting, and for some strange reasons, it was throwing some error stating cannot perform this action. Wait for 140 seconds and try again, etc. I tried multiple times. Later, I realized some of it did get posted. this is not intentional, kindly...

Hi All, I have a table of different KPI metrics collected across teams in excel files. Each KPI may be measured in different units. Hence the Targets are in % or scale of 1 to 5, or simple an absolute number, etc. The sample data and format of raw data collection table is as follows...

Hi All, Firstly, I am not able to upload file due to restriction. However, will try to provide full clarity of the data and my requirements. A typical a project would have following sequence of Steps: Sequence Standard Steps 1 Request Submission 2 Understanding Request 3 Raise...

Hi All, I am struck at a strange problem. I have dates in multiple columns, and use the max() function to get the maximum date from those multiple columns. This works fine when the data is in range. As the data now is formatted as Table, I need help on how to use Max() with column names as...

Hi All, I used to write formulas for such requirements and it is being quite some time and l lost touch. I remember using array formulas - sumproduct, mmult etc but not able to get the right combination now. :( I need formula for the below scenario. count no of columns where we have numbers...

Hi All, I was trying to understand the details in the below link: https://chandoo.org/forum/threads/word-macro-for-inspecting-document-and-removing-3-types-of-property.9435/ I am trying to look for a solution to the below scenario. This is related to MS Word files. the word files i have are...

Hi All, This situation of mine may sound more like natural language processing... the simplest would be to fix the format at (root level) who creates this text. Unfortunately, that is not in my control. so i have to find my workaround. I am sure with such huge excel knowledge base resource...

Hi All, i have simple macro file created. The MS Excel 2010 version, and inside Citrix environment, when i open the file, it takes almost 15 mins to open the file. once, it is open the functionality of macro is with good speed. The challenge is only when the excel is opening the file. It...

Hi All, lets say i have information of records like in attached file, Data tab. The data consists of account name, salesman name, 5 columns of keywords, email sent and received, etc. What I am trying to achieve is in Search Tab. I would like the user to put any word in the search criteria...

Hi, I am using VBA in Excel to connect with Outlook Sent Items folder and save the mail item in shared network drive. The macro is working fine, the challenge I face is when I try to sort the sent item to pick recently sent item as first email. The below email do works in Outlook 2013...

Hi All, I am trying to find the time taken to respond to the email received. so, I have time the email was received and the time email was responded. The catch or conditions are as follows: 1. Working hours - 8 am to 5 pm. 2. Email received after 3 pm, automatically considered as received...

Hi All, I choose this as title as it has been haunting me for quite long. :( We have an application called Filenet web application and in which supervisor logins and goes to workqueue tab, gives the from date and to date and selects queue, clicks refresh and the result shows list of tasks (13...

Hi Team, Background: I am working on tracking activities the shared mailbox and folders in it. Progress: I am able to track all the new emails incoming to specific shared mailbox inbox, and folder in it. I am stuck at a point in tracking who is moving the email from one folder to other...

Hi All, Most expected unexpected event :( I dont remember the password I set for the VBA code for my Outlook. In fact, I dont even recall setting password for the outlook VBA project. :( i tried google and could not find any help, as most of them are suggesting either paid software or...

Hi All, Most expected unexpected event :( I dont remember the password I set for the VBA code for my Outlook. In fact, I dont even recall setting password for the outlook VBA project. :( i tried google and could not find any help, as most of them are suggesting either paid software or...

Hi All, I have made a template of excel file (.xlsm). And another excel macro file called consolidator. This template is shared with 10 different users, and they track the details in the template. All these 10 files are stored in one location, and consolidator macro file on click of command...

Hi, I have an interesting problem, and need help from any of you. Let me try to put my case as simple as possible, though it sounds very crazy for me myself. Now, let me explain what is Inventory here. I get cases which are called “NewTasks”. And once you work on it, it becomes “Follow Up”...

Hi All, I am trying to find a formula and breaking my head for quite some time. I will receive data as in the attached file. Unfortunately, I should not change the data format as it is used for further processing down the line. i need total sub category based on product name. the data...

Hi Chandoo, As forum is also a product from chandoo, i thougth of placing my request here. Well, in the forums I see a lot of good questions being asked and some very interesting solutions for different members. Is it possible to make one additional feature in the forum webpage to, Option...

Hi, I was checking how to plot different color of same series chart like % of actuals above SLA% and below SLA%. I did find a very good solution from Andy Pope's site, that it can be done either with formula or with VBA. I am able to get the result replicated in my book, except for one...