Filter on first DateTime per Day

[joshua1990]

Hi community!

I have a table that shows me several records per day for each article:

Article	DateTime	Value
A	01.01.2022 01:00:00	5
B	01.01.2022 01:50:00	8
C	01.01.2022 08:00:00	6
B	01.01.2022 01:00:00	2

Each article has for each dax the same amount of rows with the same datetime.

Now I would like to sum the value for each article always for the first DateTime per Day.

How would you do that using DAX?

[Anonymous]

Hi @joshua1990 ,

Having trouble to follow.

What is the expected result?

A table like below:

Article	DateTime	Value
A	01.01.2022 01:00:00	5
C	01.01.2022 08:00:00	6
B	01.01.2022 01:00:00	2

Or a single value which is 5+6+2 = 13?

Best Regards,

Jay

[Whitewater100]

Hi:

I will attach a solution. You will see I added just a Data column to your table and the visual on page one is set to not summarize.

https://drive.google.com/file/d/1ydN4Y-C4RIwgvft_KBQgI84UzIXLWaOE/view?usp=sharing