• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent content by prasaddn

  1. P

    Read Me Page in PowerBI Dashboard - Tree or Collapse /Expand

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

    Read Me Page in PowerBI Dashboard - Tree or Collapse /Expand

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

    Sumifs - help to do sum with two rows range to match criteria

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

    Sumifs - help to do sum with two rows range to match criteria

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

    Apologies - Not spamming, server error

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

    Transpose with Number Formatting In PowerBI Dashboard- help

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

    Help - Counting the Sequence of Steps...

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

    Help - Counting the Sequence of Steps...

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

    Need Help Max() in Table

    Thank you @Peter Bartholomew!
  10. P

    Need Help Max() in Table

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

    Count numbers where the heading partially matches

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

    Count numbers where the heading partially matches

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

    Please help me with the formulae

    try explaining your requirement, if you have to do manually for couple of records as example..
  14. P

    Count If in textbox VBA

    try this.... i have given the code for two text boxes.. you can keep adding as many as you need. Private Sub CommandButton2_Click() On Error Resume Next quantcoup.Text = Abs(Not VBA.IsEmpty(ddc1.Value) And Not IsNumeric(ddc1.Value)) + Abs(Not VBA.IsEmpty(ddc2.Value) And Not...
  15. P

    Define Name Range: Formula to sort the range ascending wise

    hi, does an VBA solution work for you? or looking for only formulae based solution? Regards, Prasad DN
Back
Top