Question
We’re having trouble bringing the latest status and finished date of an Xray test run for each issue (test).
As you can see, we have some issues that have multiple values for a single issue. We are looking for a unique (last) status and finished date for a single issue.
Answer
The Xray test status can be taken from the "Tests" table > the "Status Name" field. The finished date you need is available through Power BI calculations (using data from "Tests" and "Test Runs").
To be more precise, please create a new column in the "Tests" table and use the next expression within it to locate the last test run date for each issue (test):
LAST_TEST_RUN_DATE = MAXX(FILTER('XrayTestRuns', 'XrayTestRuns'[XRAY_TEST_ISSUE_ID] = 'XrayTests'[XRAY_TEST_ISSUE_ID]), 'XrayTestRuns'[FINISHED_DATE])
