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.
Hello Everyone!
I want to do something in PBI wich is simple in excel, I have a database with countries and troops sent from the orign to a destination, the idea is that I want to know how many troops each country sent and how many retun in the same direction,
For example Germany sent to India 15, and India returned 12, so the result will be 2 troops which are pending to retun to germany
I created two regular tables, but I dont know how to do the result table which is the difference between the two regular pivot tables above
Database:
This is the data form one week so I want to see the result each week
Pivot Tables
Result table
I dont mind if i have to calculte new summarized tables as long I can get the last table
Thanks for the help!
Solved! Go to Solution.
@Anonymous,
You may add a calculated column first.
Column = LOOKUPVALUE ( Table1[Troops], Table1[Destination], Table1[Origin], Table1[Origin], Table1[Destination] )
@Anonymous,
You may add a calculated column first.
Column = LOOKUPVALUE ( Table1[Troops], Table1[Destination], Table1[Origin], Table1[Origin], Table1[Destination] )
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |