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.
I've been trying to do this through summarize and a new table but can't for the life of me figure out how to what I need.
I have 3 tables one is an Item List which has a unique key. the other two do not have anything unique to allow them to talk to each other so they go through Item List.
All three have Item Number which is the list's key.
I need to summarize a column from each by the Item Number to allow for filtering by Item Number. How do you write a column to summarize by the key? can I summarize to the Item List table?
Hi @pcowman1
It seems you may create a table with below formula.If it is not your case,please share some data sample and expected output. You can upload the .pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.For further,please refer to
How to Get Your Question Answered Quickly.
Table = DISTINCT ( UNION ( SELECTCOLUMNS ( Table1, "List", Table1[List] ), SELECTCOLUMNS ( Table2, "List", Table2[Item list] ), SELECTCOLUMNS ( Table3, "List", Table3[Item list] ) ) )
Regards,
Cherie
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 |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |