Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, my name is damian and I have the following info.
Jack 10
Paul 20
Paul 10
Michael 30
Michael 20
The issue is that I have many names.
I assemble a histogram without problems. but I want that on the x-axis when it says the names, say Michael = [2], Paul [2], Jack [1], instead of just the name.
That is, the name and number of repetitions of the record
I did the concatenation, but it returns me: Michael = [1], Paul = [1], Jack [1]
Do you know that it may be what is failing me?
I did:
n = COUNT (Table [Name])
extra = "[" & n & "]"
Table [Name] & [extra]
Where this error?
Solved! Go to Solution.
To get the expected result, you may use EARLIER Function to add a calculated column.
Column = COUNTROWS ( FILTER ( Table1, Table1[Name] = EARLIER ( Table1[Name] ) ) )
To get the expected result, you may use EARLIER Function to add a calculated column.
Column = COUNTROWS ( FILTER ( Table1, Table1[Name] = EARLIER ( Table1[Name] ) ) )
it works!
thanks a lot sam!
Hi, my name is damian and I have the following info.
Jack 10
Paul 20
Paul 10
Michael 30
Michael 20
The issue is that I have many names.
I assemble a histogram without problems. but I want that on the x-axis when it says the names, say Michael = [2], Paul [2], Jack [1], instead of just the name.
That is, the name and number of repetitions of the record
I did the concatenation, but it returns me: Michael = [1], Paul = [1], Jack [1]
Do you know that it may be what is failing me?
I did:
n = COUNT (Table [Name])
extra = "[" & n & "]"
Table [Name] & [extra]
Where this error?