Forum Discussion
Help with Complex Summarize Measure
Here is what I’m trying to accomplish: I have a table of employees, and a date table in my model. The employee table has a terminated date column. In my report, I have a date slicer. I would like t...
Use sumx function to sum your existing measure you calculated for days
Total Terminated Days = SUMX(Table1, [your measure])
parry2k
Super User
Super UserIf you can share sample data in excel file that will help to provide you the solution. It is very much doable.
Does it help if I include an example of the SQL query I would construct here?:
select sum(d.Days2Adj) from (select resourceID, DATEDIFF('d', @minDate, term_date) as Days2Adj from employees)d- parry2k
hmmm, not the logic, just the sample data, you can remove any sensitive information , share it using excel.
Sample employee table
employeeID term_date 1 1/27/2018 2 3 4 2/5/2018 5 6 7 4/15/2018 8 9 10 11 5/1/2018 12