Solved: Time calculation - Page 2

Dragos · ‎04-09-2018

Hi Expert
I'm new to power bi and I search for a solution to sum between time:
Column 1 I have name of seller.
Column 2 I have time from 00:00:00 to 23:59:59
Column 3 I have prices .
What I want to achieve is the sum of column 3 between 12:30:00 and 12:30:59 / between 12:31:00and 12:31:59/ 12:32:00 and 12:32:59.
Thank you and Regards
Dragos

Phil_Seamark · ‎04-12-2018

HI @Dragos

Had a look at this tonight (finally). The issue was with the [Time] column in your Sheet1 table. It still contained milliseconds, so I added a new column [Time2] to Sheet1 that only has hours/mins/seconds.

I also converted the TimeKey column in the new table to be time rather than text.

I have attached the PBIX file to this message.

To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post