I need to fetch a value between two columns like from columns 1 and columns 2 which is most repeated i need that one. (eg. Supposecolumns 1 columns 2A. AB. BA. CC. AD. BA. BA D
So here most repeated value is A ( A is repeated 6 times ) like this solution I need.
Go to Solution.
@Girish_123 you can use this measure to find the mode
VAR _0 =
SELECTCOLUMNS ( 'Table', "c1", 'Table'[column1] ),
SELECTCOLUMNS ( 'Table', "c1", 'Table'[column2] )
"Frequency", COUNTX ( FILTER ( _0, EARLIER ( [c1] ) = [c1] ), [c1] )
Proud to be a Super User!
New Animated Dashboard: Sales Calendar
View solution in original post
I'll try this one thank you so much
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.