Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
joshua1990
Post Prodigy
Post Prodigy

Filter on first DateTime per Day

Hi community!

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

ArticleDateTimeValue
A01.01.2022 01:00:005
B01.01.2022 01:50:008
C01.01.2022 08:00:006
B01.01.2022 01:00:002

 

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?

2 REPLIES 2
Anonymous
Not applicable

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
Solution Sage
Solution Sage

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 

 

Whitewater100_0-1652904280573.pngWhitewater100_1-1652904310885.png

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.