Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have this following table. I want to get latest contacted Date and User Details.
Date | UserName | Type | Followup |
24-04-2016 2:35 AM | Mike1294 | Yes | |
24-04-2016 1:45 AM | Anand8372 | Call | Yes |
24-04-2016 2:15 PM | Kristy9382 | Yes | |
Anand8372 | |||
25-04-2016 2:25 AM | Mike1294 | Yes | |
Anand8372 |
I want to achieve results like below.
Date | UserName | Type |
24-04-2016 | Kristy9382 | |
25-04-2016 | Mike1294 |
Thank you inadvance.
Hi,
Try this
=MAX(Data[Date])
=LOOKUPVALUE(Data[Type],Data[Date],[Last contact date])
Hi @rocky09,
Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.
Best Regards!
Dale
Hey,
I created two calculated columns in my table,
the first column just retrieves the date part of the my datetime column like so
JustDate = DATE(YEAR('Table1'[ContactDateTime]),MONTH('Table1'[ContactDateTime]),DAY('Table1'[ContactDateTime]))
the 2nd column marks the row with the latest DateTime for each day with TRUE otherwise FALSE like so
Is Latest Contact = IF( AND('Table1'[ContactDateTime] = CALCULATE( MAX('Table1'[ContactDateTime]) ,ALLEXCEPT('Table1',Table1[JustDate]) ) ,FORMAT('Table1'[ContactDateTime],"YYYY-MM-DD") <> "" ) ,"TRUE" ,"FALSE" )
My table finally looks like this
I would hide my JustDate column in report view and use the column Is Latest Contact to filter the rows accordingly.
Hope this helps
Regards
Tom
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |