Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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.
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.