Use only last value

[sw123]

Hi,

I have a table that looks like this:

Date	Item	Amount	Event
14.5.2024	A	2607,09	A
14.5.2024	A	2285,214	B
14.5.2024	A	2090,322	C
14.5.2024	B	9750	A
14.5.2024	B	9000	B
14.5.2024	B	9000	C
13.5.2024	A	2622	A
13.5.2024	A	2345	B
13.5.2024	A	2765	C
13.5.2024	B	9876	A
13.5.2024	B	9200	B
13.5.2024	B	9200	C

I would like my report to show only the first value per item and date. How do I do that?

Thankful for help!

[ddpl · Accepted solution]

@sw123 Cerate Measure as per below and use as filter

Measure = SWITCH(

    TRUE(),

    MAX('Table (4)'[Date]) = MAX('Table (4)'[Date]) && MIN('Table (4)'[Event]) = "A", 1,0 )

[Anand24]

@sw123 ,
How are you determining the first value for a day if time is not available in the data? What should be the expected output for the sample data you provided?