Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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. Suppose
columns 1 columns 2
A. A
B. B
A. C
C. A
D. B
A. B
A D
So here most repeated value is A ( A is repeated 6 times ) like this solution I need.
Solved! Go to Solution.
@Girish_123 you can use this measure to find the mode
_Measure =
VAR _0 =
UNION (
SELECTCOLUMNS ( 'Table', "c1", 'Table'[column1] ),
SELECTCOLUMNS ( 'Table', "c1", 'Table'[column2] )
)
RETURN
MINX (
TOPN (
1,
ADDCOLUMNS (
_0,
"Frequency", COUNTX ( FILTER ( _0, EARLIER ( [c1] ) = [c1] ), [c1] )
),
[Frequency]
),
[c1]
)
Proud to be a Super User!
New Animated Dashboard: Sales Calendar
@Girish_123 you can use this measure to find the mode
_Measure =
VAR _0 =
UNION (
SELECTCOLUMNS ( 'Table', "c1", 'Table'[column1] ),
SELECTCOLUMNS ( 'Table', "c1", 'Table'[column2] )
)
RETURN
MINX (
TOPN (
1,
ADDCOLUMNS (
_0,
"Frequency", COUNTX ( FILTER ( _0, EARLIER ( [c1] ) = [c1] ), [c1] )
),
[Frequency]
),
[c1]
)
Proud to be a Super User!
New Animated Dashboard: Sales Calendar
I'll try this one thank you so much
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.