Show only data from the latest date

[oitp]

Hi, I have a table as below (example). I want to create a report only showing the latest event for each customer but I can't seem to wrap my head around it. 

Any help is welcome 🙂

CustomerNr1	Event 1	19/01/01
CustomerNr2	Event 1	19/03/03
CustomerNr1	Event 2	19/02/02
CustomerNr2	Event2	19/04/04

I want to show this view:

CustomerNr2	Event 1	19/03/03
CustomerNr2	Event2	19/04/04

[cnweke]

The MAX() function solves this problem. 

Maxdate = MAX(date) <- measure.

Then add it to your column where your date normally is

[oitp]

I think I might be doing something wrong. If I create a measure like this: MaxDate = MAX('Calendar'[Date]) and then use this together with my column called "CustomerName" I end up with all the Customers in one column and todays date in the other.

So I don't get the latest event date for the customer, just the latest possible date. 😞

[cnweke]

can you add event to that table?

[oitp]

Yes, but even with Events added I still end up with the same result. I have verified that my date column is formatted as Date/Time.

[cnweke · Accepted solution]

hmmm, try a matrix instead of a table. Then you should be fine.

[oitp]

Ah, thanks alot @cnweke ! You made my day, it works fine with matrix 🙂