Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Adding Last data point label to a 12mth Calculation

Hi,   I have managed to setup a 12mth rolling measure that calulates a frequency rate of injuries against hours: '12mth TRIFR' = '12mth injury count' * 1000000 / '12mth hours' '12mth injury coun...
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

Anonymous I am surprised that your VALUES() part doesn't throw an error. The second parameter of DATESINPERIOD expects a single start date. Maybe VALUES() returns a single row table.

 

Please provide sanitized sample data in usable format (not as a picture - inserting it into a table would be good) and show the expected outcome.