I'm a new user to Power BI and trying to replicate some functionality that I use in Excel.
Using an existing Excel table which has entries of A1:A10.
I use the following =Countif(A:A,A1) in cell B1, which I then copy down to the end of the data B10
Against each row (B1:B10) it would then show how many times the text in the referenced cell appears in the array.
I want to try and replicate this in power query.
I've searched and searhced but can't find anything that gives me the individual answers.
Many thanks Lee