Forum Discussion
Solved
Most Frequent value in a column - through calculated columns
Hi I need to do the below: 1. Determine the most frequent text value in column (Answer) and display that in a calcualted column (C1) 2. Count the number of times the most frequent value occurs in ...
For your reference.
Step 1: I make a summarize table. (After Step 2, I add a column 'Number'.)
Number = COUNTROWS(RELATEDTABLE('Data'))
Step 2: I add a relationship.
Step 3: I add 2 columns below.
C2 = MAX('Summarize Table'[Number])
C1 = LOOKUPVALUE('Summarize Table'[Answer],'Summarize Table'[Number],[C2])
mickey64
Super User
Super UserFor your reference.
Step 1: I make a summarize table. (After Step 2, I add a column 'Number'.)
Number = COUNTROWS(RELATEDTABLE('Data'))
Step 2: I add a relationship.
Step 3: I add 2 columns below.
C2 = MAX('Summarize Table'[Number])
C1 = LOOKUPVALUE('Summarize Table'[Answer],'Summarize Table'[Number],[C2])