Forum Discussion
Time calculation
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.
Hi Dragos
If you create a Time table using the following calculated table code, you can create a relationship between the [TimeKey] column in this table with the [time] column in your main table. Then you can use the [Minute Group] field from the new table on a visual along with the [price] column in the values (as a SUM). What datatype is your [time] column?
Time Table =
VAR Hours = SELECTCOLUMNS(GENERATESERIES(0,23),"Hour",format([Value],"0#"))
VAR Minutes = SELECTCOLUMNS(GENERATESERIES(0,59),"Mintutes",format([Value],"0#"))
VAR Seconds = SELECTCOLUMNS(GENERATESERIES(0,59),"Seconds",format([Value],"0#"))
RETURN SELECTCOLUMNS(
CROSSJOIN(Hours,Minutes,Seconds),
"TimeKey" , [Hour] & ":" & [Mintutes] & ":" & [Seconds],
"Minute Group" , [Hour] & ":" & [Mintutes] & ":00"
) Hi Phil
Thank you for your fast reply .
The format is date and time .
Created another column only with time as attached.
BR
Dragos
The time table works perfectly.
Now i don't really understand how can i bring individualy the sum per minute and not for all sales .
Regards,
Dragos
Hi Dragos
The reason it is blank is because there are no matching rows through the relationship.
Are all your values in your Execution Time field the same day? or do they vary?
Hi Phil
The dates are different .
Every day new sales .
What i did i created a new column only with the time and did the relationship between mytable[time] and timetable[minute group].
And then to filter by day .
I thought this way will match.
Thank you and Regards,
Dragos
