AnonymousNot applicable5 years agoSolvedDax 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 r...Show MorePC27905 years agoNot sure if this is the most efficient way, but I was able to address your requirement using Power Query and DAX.Uploading a sample file here for you to access
PC27905 years agoNot sure if this is the most efficient way, but I was able to address your requirement using Power Query and DAX.Uploading a sample file here for you to access
PC27905 years agoNot sure if this is the most efficient way, but I was able to address your requirement using Power Query and DAX.Uploading a sample file here for you to access
PC2790Community Champion5 years agoNot sure if this is the most efficient way, but I was able to address your requirement using Power Query and DAX.Uploading a sample file here for you to access
AnonymousNot applicable to PC27905 years agoThanks PC2790. I will have a look at this today. Thank you. PC2790Community Champion to Anonymous5 years agoHey, Did it work for you or you are looking for something else?
AnonymousNot applicable to PC27905 years agoThanks PC2790. I will have a look at this today. Thank you.
PC2790Community Champion to Anonymous5 years agoHey, Did it work for you or you are looking for something else?
Related contentDivide formula in power queryPower Query FormulaLookup Formula in Power QueryIf formulaPower Query dates
