Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
I have a log of changes that took place for a series of items. I need to determine what the last change was and to what value it was set on the first day of changes being made for each individual item.
Table with expected results outlined below.
Item name | Datetime US (simplified here) | Original Value | New Value |
Item1 | 01/01/24 09:00 | null | 100 |
Item1 | 01/01/24 10:00 | 100 | 50 |
Item1 | 02/01/24 09:00 | 50 | 200 |
Item 2 | 02/01/24 09:00 | null | 1000 |
Item 2 | 03/01/24 12:00 | 1000 | 2000 |
Item 3 | 05/01/24 10:00 | 400 | 300 |
Item 3 | 05/01/24 10:01 | 300 | 500 |
Item 3 | 06/01/24 09:00 | 500 | 550 |
Item 4 | 01/01/24 11:00 | null | 750 |
I have a good idea of how to do this in SQL but as this data comes straight from source I need to resort to using either DAX or M-Query for this task, and I would appreciate any help to achieve this!
Solved! Go to Solution.
For fun only, to showcase the power of Excel formulas,
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LearnAndPractise(Everyday) ) |
User | Count |
---|---|
84 | |
76 | |
74 | |
48 | |
39 |
User | Count |
---|---|
114 | |
56 | |
51 | |
42 | |
42 |