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 have five tables that I've been sorting with the merge data function. Each table 1-5 has cumulative data from the prior table. For example, table 1 shows 10 people are eligble to retire in one year, then table two has 20 people eligible to retire in 2 years (that also includes the same 10 people from table 1). I want to create a single table that has all the people eligible retire in 5 years, but for each person the number of years in which they are first eligble to retire.
I merge a sort two tables at a time (e.g. take table 5, merge with table 4, sort for duplicates and filter out duplicates), then press close and apply. More closly, table 5 has 50 entries after I merge and filter out duplicates I am left with 100 entries. Then I take table 4 merge with table 3, sort for duplicates and filter out duplicates)..... then when i go to close and apply the data in table 5 reverts back to the original number of entries (i.e. 50 entries).
Thoughts on what i'm doing wrong and/or how i can create one table showing people (by name) and the first year they are eligible to retire?
Solved! Go to Solution.
Check the solutions in links below that use Power Query and DAX.
Check the solutions in links below that use Power Query and DAX.
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 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |