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

Search results

  1. D

    Calculating Max date selected using Date Slicer

    Please ignore. I have solved it.
  2. D

    Calculating Max date selected using Date Slicer

    Hi, I am creating a report which has one Date Slicer (a slider to change the start or end dates). If start date and end dates are changed by user to view the historical numbers (lets say to see numbers for previous quarter), how would I calculate (using DAX formula) that what date range user...
  3. D

    Need to populate Bullets and Sub-Bullets numbering

    Thanks Alan for the help:). I can merge this to one cell. I will test your solution once at my system. Thanks again.
  4. D

    Need to populate Bullets and Sub-Bullets numbering

    please help with the query posted.
  5. D

    Need to populate Bullets and Sub-Bullets numbering

    Hi, We have around 100 workbooks. Each workbook has a table. Each table grid has 100s of cells. Every cell has some bulleted text. Sample is given in attached excel in "Input text" sheet (I gave only 1 cell here but there is a table of such cells). The problem is that these excels needs to be...
  6. D

    Help with Filter Function

    Thanks Chihiro :)
  7. D

    Help with Filter Function

    Hi, I have a dataset named "AllData". It has a column named as "ObjectID". I want a filtered table basis the criteria that values in ObjectID column contains a value string "SearchString". The formula syntax for filter function is FilteredDataTable =...
  8. D

    Query on (CountA with All function)

    Need one more help (again with counting) I have a list of repeated values in a column. Want to show number of times a values is repeating in next column. For example: Column-1 Column-2 A 3 A 3 A 3 B 2 B 2 C...
  9. D

    Query on (CountA with All function)

    Thanks GraH for the suggestion and explanation. It helped me understanding the logic.
  10. D

    Query on (CountA with All function)

    Hi All, I was wrote following DAX formula to count distinct values present in a column. "=CountA(All(EmpTable[EmpName]))" but it gives error Then I tried "=Countrows(All(EmpTable[EmpName]))" and it worked. Can you make me understand why first formula didn't work? "ALL" function provided...
  11. D

    Unable to add PowerQuery data to DataModel in Excel2016

    Thanks Chihiro for the help:)
  12. D

    Unable to add PowerQuery data to DataModel in Excel2016

    I have "Professional Plus 2016" version and hopefully it has latest version of PQ and PP. But still I am unable to add query data to data model.
  13. D

    Unable to add PowerQuery data to DataModel in Excel2016

    Hi, I have my base data in MS Access. I connected database with Excel using PowerQuery and modified the data in a usable structure and then clicked on "Only Create Connection" check box and then selected "Add this data to the Data Model". Now in Power Pivot, I don't see the table there. Once I...
  14. D

    Help with DAX formula

    Hi All, Is this possible to calculate that how many times a value is repeating? For Example, lets assume I have some values in a column-A and it has duplicates as well. I want count of repeats in column-B like shown below: Column1 Column2 A 8 A 8 A...
  15. D

    Help with DAX formula

    Please help me with the solution using DAX as my dataset is too large to handle in excel.
  16. D

    Help with DAX formula

    Hi Narayan, Attached is pivot based solution. Thanks, DJ
  17. D

    Help with DAX formula

    Hi Narayan, A, B & G are appearing in 2 months C, D & F are appearing in 3 months So users appearing in 2 months are 3 similarly users appearing in all 3 months are 3. I wish I could upload file from my office system.....I'll try using my personal system to upload a pivot table based solution...
  18. D

    Help with DAX formula

    Hi Narayan, Thank you for the reply. Lets take this as a sample data for the users who visit a community page on daily basis (I created sample only for the single appearance of the users in a month). Right now I have data for 3 months of these users. Some users visited that page in all 3...
  19. D

    Help with DAX formula

    Hi All, I need help with calculating team wise number of users who are visible in at least 2 months out of last 3 months data. I have uploaded a sample file. Also a small desired result mentioned in same worksheet. Thanks, DJ
  20. D

    Connection Strings

    Thanks Narayank991 :) If I have further query, will contact again.
  21. D

    Connection Strings

    Hi All, Can someone help me get some simple examples on connection strings? also which library reference needs to be selected (if applicable) ? If there are online study material is available, please share that too. Thanks, DJ
  22. D

    Named Range question

    Thanks bosco_yip for the info. This means that that I can type "C"/"R" in NameBox instead of keyboard shortcuts Ctrl+Space or Shift+Space to select entire Column/Row. There is no further application of these 2 default names. Right?
  23. D

    Named Range question

    I referred to https://exceljet.net/named-ranges link and found the naming convention in it, but it is not mentioned about the usage of reserved names.
  24. D

    Named Range question

    Hi All, I was trying to create a demo for my friend to help him understand creating dependent lists. While doing so I noticed a strange scenario which is I am mentioning below....please help me understand why this happens. I entered sub-category names in column-A...
  25. D

    Selecting multiple items from a pivot's page field

    Hi All, I am trying to select multiple items from a pivot table's page field. Below code is not working. When I record macro to do this....it only sets property as "False" for the not selected items...nothing for selected items...
Top