Forum Discussion

sunny27's avatar
sunny27
Frequent Visitor
7 years ago
Solved

Filter based on summarize dax

Hi,   How can we summarize the following data? EmployeeNumber Status Date 100 1 1/1/2017 100 2 2/1/2017 100 3 3/1/2017 100 4 4/1/2017 101 1 4/25/2017 101 2 5/25/...
  • Anonymous's avatar
    Anonymous
    7 years ago

    Could you simply include them in a matrix and use "Latest Date" and "Max of Status"?