Recent content by DJ

Please ignore. I have solved it.

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

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

please help with the query posted.

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

Thanks Chihiro :)

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

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

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

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

Thanks Chihiro for the help:)

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.

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

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

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