Hi All,
I am studying Risk and I would like to calculate the of the attached using a DAX measure.. I am so close but can't see what I am doing wrong. I would appreciate it. help.
Hi All,
I am studying Risk and I would like to calculate the of the attached using a DAX measure.. I am so close but can't see what I am doing wrong. I would appreciate it. help.
Sorry forgot the formula
(Number of injuries in the last 12 months / Total hours worked in the same 12 months ) * 1,000,000 = TRIFR
Hard to check manually, because the two datasets cover different time periods... and the sample is rather massive...
but.
=10^6*COUNTIF(Table2[Injury Date Reported],">="&EDATE(B1,-12))/SUMPRODUCT((DATEVALUE(Table1[Month and Year])>=EDATE(B1,-12))*Table1[Hours Worked])
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Thanks Glenn.
You're welcome.
It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.
Finally, if that takes care of your original question, please select "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks