Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Latest Date

Hi All,   I have a table with the structure below:   Process Number Date Department Description 354152 05/10/2019 10:24:20 AM IT 354152 05/10/2019 10:29:10 AM Business 354152 0...
Need Help
  • AntrikshSharma's avatar
    AntrikshSharma
    6 years ago

    Like this?

    Column =
CALCULATE (
    MAX ( Jen[Date] ),
    ALLEXCEPT ( Jen, Jen[Process Number], Jen[Department Description] )
)
AntrikshSharma's avatar
AntrikshSharma
Community Champion
6 years ago
sorry Jen looks like I am confused, can you share again what the issue is?
Anonymous's avatar
Anonymous
Not applicable
6 years ago

The issue is that it shows two lines instead of one with the latest date and with the latest user. When I try to use the last code you sent i have an error below