Forum Discussion
Solved
Managing relationships between datasets with date variable
Hello, I am a new user of Power BI and am currently working on establishing relationships between several datasets that include variables: Feeding data for different groups of farm animals...
clean up your data and create a data model
Adding injuries to that chart will create cognitive overload. Use separate visuals.
Read about how to handle SCD2 - Slowly Changing Dimension Type 2
Thank you.
Please see samples of datasets below that I would like to create relationships for. I have different records for different dates, and relating records across different datasets for corresponding dates for each pen, then between different pens, is what I am after. Not sure if this clarifies..
Feeding dataset for one of the pens:
| Date | Feed weight |
| Sun 07 Jul | 0 |
| Mon 08 Jul | 0 |
| Tue 09 Jul | 0 |
| Wed 10 Jul | 480 |
| Thu 11 Jul | 960 |
| Fri 12 Jul | 960 |
| Sat 13 Jul | 1,200 |
| Sun 14 Jul | 0 |
| Mon 15 Jul | 0 |
| Tue 16 Jul | 800 |
| Wed 17 Jul | 2,000 |
Injured weight records for one of the pens:
| Date | Injured ind. weight |
| 06-Jul | 130 |
| 07-Jul | 200 |
| 10-Jul | 170 |
| 11-Jul | 50 |
| 12-Jul | 150 |
| 13-Jul | 200 |
| 13-Jul | 200 |
| 14-Jul | 220 |
| 15-Jul | 200 |
| 15-Jul | 200 |
| 18-Jul | 150 |
| 18-Jul | 80 |
Temperature dataset:
| 30/06/2024 19:00 | 25.113 |
| 30/06/2024 20:00 | 25.21 |
| 30/06/2024 21:00 | 25.453 |
| 30/06/2024 22:00 | 25.283 |
| 30/06/2024 23:00 | 25.331 |
| 01/07/2024 00:00 | 24.968 |
| 01/07/2024 01:00 | 25.283 |
| 01/07/2024 02:00 | 24.895 |
Dimension table:
| Pen Number | Start Number | Start Weight | Start Average | Origin |
| A1 | 1000 | 10000 | 10 | UK |
| A2 | 999 | 12000 | 12 | UK |
| A3 | 1200 | 11000 | 9 | US |
| A4 | 1300 | 10000 | 8 | US |
| A5 | 1010 | 10000 | 10 | ITA |