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

Like this?

Column =
CALCULATE (
    MAX ( Jen[Date] ),
    ALLEXCEPT ( Jen, Jen[Process Number], Jen[Department Description] )
)
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you very much AntrikshSharma .

  • AntrikshSharma's avatar
    AntrikshSharma
    Community Champion
    6 years ago
    Great! You're welcome!