Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
87 | |
79 | |
62 | |
61 | |
59 |
User | Count |
---|---|
166 | |
114 | |
99 | |
73 | |
65 |