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])
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)dhmmm, 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 Use sumx function to sum your existing measure you calculated for days
Total Terminated Days = SUMX(Table1, [your measure])
Brilliant! I think SUMX and I will become friends. Thank you :)