Choose the record with the last date

[Anonymous]

Hi everybody,

I would like to ask for help. I have table with rows and I would like to choose value from row, where the date is the last.

Example:

Customer | Type | Date | Note

ABC | E-mail | 01/07/2019 | Sended

ABC | Call | 02/07/2019 | He promised something ...

ABC | Call | 03/07/2019 | He is not answering.

How to receive values from row with date 09/07/2019? I tried to use DAX using LAST function. It works in Desktop. But after few day I receive bad feedback, because it doens't work, but synchronization works.

Do you know how to solve it? Thank you for help.

Mary

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

You want to choose the max date for each Customer, right?

If so, create measures

Measure = CALCULATE(MAX(Table1[Date]),FILTER(ALLSELECTED(Table1),Table1[Customer]=MAX(Table1[Customer])))

Measure 2 = IF([Measure]=MAX(Table1[Date]),1,0)

What does this mean?

"But after few day I receive bad feedback, because it doens't work, but synchronization works"

Do you update the data to have lastest data inside the data model?

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.