Hello, this is my first ever post so bear with me please . I have a power pivot table and I'm struggling to find a formula that would return the value that appears most often in a column. My table(called "Table") has a similar format to the one in the attached image but quite larger and with more columns. I chose a power pivot as I needed a few calculated fields that are more complex.
Capture.JPG
In this example, I would need a formula that would return the value "Astronaut" (will always be a text/general value) because this is the value that appears most often in the Dreamjob column. I was thinking that using Maxx and Distinct(I understand this returns a column of values) might work but I cannot find the right syntax. I would prefer to do this without adding another column to the table as the table is huge as it is and is updated regularly (a few times a day). Is there any way to do this?
Thanks
Alex
Bookmarks