Forum Discussion
Count items where date is max
Hello everybody, I have an interesting problem and need your help. Use Case: Imagin, you get a list of ticket changes. A Ticket can be in the status "to do", "doing" and "done". You receive a...
Ildar7070 check this video on my YT channel which addresses something similar. How to get value of each product based on the most recent transaction - Power BI - YouTube
And don't forget to subscribe to the channel
😌
Cheers,
P
parry2k Unfortunately, this is not as easy as I thought. Calculating the last item only is not helping because this only iterates once over the whole table. But I need to get the latest value for each iteration.
In other words, for each day, give me a table with all the changes that happened until this current day and count only the latest changes per key. Then go into the next iteration and do the same thing for next day