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,
I'm having trouble figuring this out. Any help is appreciated, thank you.
I have a dataset, sampled below:
DealID | # | DealDate | ExitDate |
910-09T | 1 | ||
202-76T | 1 | 2/22/2013 | |
849-35T | 1 | ||
362-32T | 1 | 1/30/2015 | 1/30/2015 |
531-76T | 1 | 8/13/2015 | 8/13/2015 |
606-25T | 1 | 11/9/2015 | 11/9/2015 |
1709-89T | 1 | 4/30/2020 |
The task is to, for each # (which represents company), take the earliest DealDate, and Latest ExitDate, and turn it into one row. Deal ID isn't needed, just there to represet each time a deal was made in database.
So for this company, company 1, i would like for it to have only (First Deal) 2/22/2013 and (Lateset Exit)11/9/2015.
Solved! Go to Solution.
Hi Senad,
1. Let's call your current table Detailed. We can start by creating a mini table called Summary that includes the distinct Company IDs:
Hi Senad,
1. Let's call your current table Detailed. We can start by creating a mini table called Summary that includes the distinct Company IDs:
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 | |
105 | |
77 | |
67 | |
63 |
User | Count |
---|---|
144 | |
107 | |
105 | |
82 | |
69 |