Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I could use some help trying to figure out how to...properly count/aggregate data from two tables.
Let's say I have a table called SoftwareInstalled, similar to this:
And I have a Target table like this:
I'd like to add a calculated column or create some (aggregate?) table that gives me this:
I'm pretty new to PowerBI, and I've tried searching for some pointers/tutorial that points me in the right direction, but no luck so far. Is this doable in PowerBI?
Solved! Go to Solution.
@Anonymous ,
You may use Merge Queries (Table.NestedJoin) in Query Editor or LOOKUPVALUE Function in DAX.
@Anonymous ,
You may use Merge Queries (Table.NestedJoin) in Query Editor or LOOKUPVALUE Function in DAX.
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |