The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
81 | |
63 | |
56 |
User | Count |
---|---|
248 | |
123 | |
111 | |
78 | |
74 |