Forum Discussion
Assistance with Table Measures
Hi all. Thank you for taking the time to review my post. I am needing assistance in creating a new table namely Top Time Spent, where it pulls data from two other tables namely Time Logs and Tasks. See below tables and expectance.
Time Logs table
Tasks table
Expectation
I want to create a table called Top Time Spent, that lists the total time logged per Author, per Task. Example,
Is this something someone can assist me with please?
I have given it a go and am struggling with the measures.
Create a relationship between the "Time Logs" table and the "Tasks" table using the "Task Id" column.
create the "Top Time Spent" table:
TopTimeSpent =
SUMMARIZE(
'Time Logs',
'Time Logs'[Author],
'Time Logs'[Task Id],
"Total Time Logged (hrs)", SUM('Time Logs'[Time Logged (hrs)])
)
2 Replies
Create a relationship between the "Time Logs" table and the "Tasks" table using the "Task Id" column.
create the "Top Time Spent" table:
TopTimeSpent =
SUMMARIZE(
'Time Logs',
'Time Logs'[Author],
'Time Logs'[Task Id],
"Total Time Logged (hrs)", SUM('Time Logs'[Time Logged (hrs)])
)Hi Shaun_Fourie , Please try below DAX formula
Total Hours spent =
SUMMARIZE(
Time logs table,
Time logs table[Author],
YourTable[Task ID],
"Total Hours", SUM(Tim Logs Table[Hours logged in])
)Let me know if it works for you.
