Forum Discussion
Helper IIIDate filter across two tables
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,
4 Replies
- Pragati11
Super User
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
mwen90Thank 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?
NidhiBhusariHelper IV
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!
