Forum Discussion
Dax or Power Query formula
Hi All
Below is a snapshot of some data I am trying to clean.
The id will be the same with the attempts 1-5 and the worktime (secs) is actually a running total. So, I need to only report on the worktime of attempt 5 (as that is the actual amount of time it took) but need the other 4 attempts in there for performance evalution.
I need to be able to say: if attempt nr is > 1 and the ID is the same then only show the worktime (secs) of the row with the greatest attempt nr.
I am just not sure on how to say this in Dax or Power Query. Any ideas on how I may be able to do this?
Cheers
Karen
5 Replies
- YukiK
Impactful Individual
In Power Query, you could add a conditional column that flags 1 if "Attempt" is 5, and 0 otherwise.
If this helped, please select as the solution!
Thanks YukiK. Unfortunately that won't work. I need something that says, if the id is the same check how many attempts are in the attempt column and only add the latest attempt (so that could be 2, 3, 4 or 5) to all 1 attempts. Just not sure how to do it. 🤔
