Forum Discussion
Count rows (duplicates) in Query Editor
I have a table "Sales _Offers" and i have a column "Name_trimmed_striped" I want to add a new column that make a count for each line how many times it occures (NOT IN DAX, but still in the impo...
I did not accept this as a solution, sinces it does exactly what i did not want, It was NOT supose to happen in DAX but during import. - also if you want to do it in dax, then there is a much shortwer and more efficiant way to do it using "Earlier"
Count number of occurences = CALCULATE(COUNT('Sales_Offers'[Name_trimmed_striped]), 'Sales_Offers'[Name_trimmed_striped] = EARLIER('Sales_Offers'[Name_trimmed_striped]))
But thank you for taking time to try and help me - and sorry if I did not formulate the question precise in the opening question Anonymous
This is still not the solution i wanted since i wanted it in import, but it is better than the one that was accepted as a solution (not by me)