Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
My data:
Client Update History | ||
Product | Update Date | to Version |
A | 1/1/2016 | 2.1 |
A | 2/1/2016 | 3.1 |
A | 3/1/2016 | 3.5 |
A | 4/1/2016 | 3.6 |
B | 2/1/2016 | 4.7 |
B | 3/1/2016 | 4.9 |
B | 4/1/2016 | 5.1 |
C | 2/1/2016 | 6.2 |
I need to extract the latest (or Current) client version like:
Product | Clients Current Version |
A | 3.6 |
B | 5.1 |
C | 6.2 |
not sure if I need to use Group By or Summarize with a Max - help please
thank you!
Hello, you can obtain the current version with this :
CurrentVersion = IF ( HASONEVALUE ( Table1[Product] ), CALCULATE ( VALUES ( Table1[to Version] ), FILTER ( Table1, Table1[Update Date] = MAX ( Table1[Update Date] ) ) ) )
User | Count |
---|---|
94 | |
79 | |
73 | |
63 | |
60 |
User | Count |
---|---|
108 | |
100 | |
77 | |
63 | |
61 |