Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hey everyone! I'm new to PowerBI and I'm very interested in learning more about it.
Let's say I have a couple of csv files with 1)a list of pokemon names and type etc... 2) a list of people that I have with also other columns DOB, Address, etc..
How can I calculate the number of people that have the same first name as a pokemon?
Also if you guys have any suggestions for a new user please let me know!
Thank you!
Solved! Go to Solution.
hi @jk1
Try this: Change the name of tables and columns accord to your data
CountNames = COUNTROWS ( FILTER ( Table2, Table2[First Name] = LOOKUPVALUE ( PokemonTable[Pokemon Name], PokemonTable[Pokemon Name], Table2[First Name] ) ) )
h
hi @jk1
Try this: Change the name of tables and columns accord to your data
CountNames = COUNTROWS ( FILTER ( Table2, Table2[First Name] = LOOKUPVALUE ( PokemonTable[Pokemon Name], PokemonTable[Pokemon Name], Table2[First Name] ) ) )
h
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |