Date filter across two tables

[mwen90]

Hi, 

I have 2 tables which have a relationship.

Table 1 - Has my total workers 

Table 2  - First Aid information 

I've linked these to create the frequency rates. But I can only get calculations to show my injuries as a total count. I need to calculate these per month, so in a table I have;

Date: Month / Workers for month / injuries -Classification A / injuries classifcation B / Frequency Rate - Classification A / Frequency rate - Classifcation B

Anyone know how I can achieve this? I've tried to create a date table and use this but its not working,

Cheers,

[NidhiBhusari]

Hi @mwen90 can you please provide sample dataset or give more details so to clearly understand your requirement?

[mwen90]

Hey @NidhiBhusari  please see the sample file here https://drive.google.com/drive/folders/1o-w5BZBVZCHkfNboDbWg5soJBsnXENTO?usp=sharing @Pragati11  

Description also in comment below, thank you so much for the help again!

[Pragati11]

Hi @mwen90 ,

I don't think you have provided enough information here.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Thanks,

Pragati

[mwen90]

Thank you for the response / help!

In here is what I am trying to achieve: Total LTI and Total MTI = FirstAId table. 

LTIFR and MTIFR = Total manhours from Manpower Table 

If date comes from Manpower table, LTI or MTI count is total across all months. So I can't filter back to June and have LTI = 0, as it is counting it as 1 (one for project).

How do I do this?