Recent content by prasaddn

I tried with Unified column of dates, but that will help to address fetching of in progress projects. However, the projects created count, fetching the details is seeming very challenge. appreciate if any of the experts here can share thoughts and work-around if they have faced similar...

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...

Thank you @Monty for the suggestions, will try to explore them.

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...

Thank you ETAF! This works. I think i had lost my mind. :D

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 @vletm, Thank you for taking a loot at my post. I apologies for not able to put up the sample file, I will try to upload one shortly. meanwhile, request if we can assume the My Data starts from A1 cell with header. I will tweak and adjust to columns in my actual file accordingly...

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...

Thank you @Peter Bartholomew!

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...

LOL :D yes, I just realized it as well. thank you. Regards, Prasad DN