Forum Discussion
Adding a new column with a loop
Hello. I'm quite new to Power BI and I couldn't describe the problem well in the title so let me explain it here. I'm handling data about journal publications. I have a query 1 which has the foll...
Stachu
Community Champion
Community ChampionI would start with unpivoting the 1st table (in PowerQuery) to have the authors in rows rather than columns
Then I would suggest to use a 2nd table as a basis - and count the nr of unique publications that share the authours between two tables