Forum Discussion

Frequent Visitor

9 years ago

Solved

DAX Help: Extract value based on last execution

Hi, I have a below scenario: Timestamp CaseID CaseTitle Status 8-16-2017 5:00 1 TestCase A Pass 8-16-2017 5:00 2 TestCase B Pass 8-16-2017 5:00 3 TestCase C Pass 8-16-...

Need Help

TomMartens
9 years ago
Hey,

maybe this would be a solution, I'm counting the caseid (distinct count) to get the numbers in this table
I did not use a measure I just changed the Aggregate function in the visuals pane and renamed the column in the visual

Maybe now I'm getting closer

TomMartens

Super User

9 years ago

Hey,

I created a calculated column using this DAX

Latest Status = 
var currentCaseID = 'Table1'[CaseID]
var maxTimeStamp = CALCULATE(
    MAX('Table1'[Timestamp])
    ,ALLEXCEPT('Table1',Table1[CaseID],Table1[CaseTitle])
)
return
LOOKUPVALUE(Table1[Status], 'Table1'[Timestamp], maxtimestamp, Table1[CaseID], currentCaseID)

The values for this column will look like this