Forum Discussion
v-bastei
Microsoft Employee
Microsoft EmployeeLongest test duration per test name per Log_ID
Hi, I have a table which contains list of tests results. The main columns are: - Log_ID - iteration name - Test - The test name which could be repeated in the same Log_ID multiple times ...
Hi v-bastei ,
How about this:
Here the DAX:
Measure = CALCULATE ( MAX ( Table[Runtime] ), Table[Type] <> "Build", Table[State] = "PASSED" )Does this solve your issue? 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
tackytechtom
Most Valuable Professional
Most Valuable ProfessionalHi v-bastei ,
Please could you provide the exact sample data for your expected result? Also, you want it to be solved in Power Query and not as a DAX measure, correct?
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/