Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Excel formulas into DAX

Looking to see if I can easily get something into a column that will operate like my current formula here:   {=MAX(IF([Employee Number]=[@[Employee Number]],[Activity Date Value]))}   Overall, lo...
Need Help
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, Anonymous 

     

    You can try the following methods.

    Sample data:

    Measure:

    Latest Date =
CALCULATE (
    MAX ( 'Table'[Date] ),
    FILTER (
        ALL ( 'Table' ),
        [Employee Number] = SELECTEDVALUE ( 'Table'[Employee Number] )
    )
)

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ToddChitt's avatar
ToddChitt
Super User
4 years ago

Please include some sample data and the formula you have now.

 

Suppose you have data as follows

Person A  |  4/4/2022

Person A  |  5/5/2022

Person B  |  1/1/2022

Person B  |  2/1/2022

 

And you create a MEASURE with the following: 

[Latest Date] = MAX ( 'my table'[my date] )

 

A table visual that doe NOT include the Person column will show:

5/5/2022

(because that is the MAX across all Persons

But if you include Person, then you should get this:

Person A  | 5/5/2022

Person B  |  2/1/2022

This correctly shows the MAX for each Person.