Forum Discussion
Choose the record with the last date
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
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
MaggieCommunity 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.
1 Reply
v-juanli-msftCommunity Support
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
MaggieCommunity 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.