Forum Discussion
Managing relationships between datasets with date variable
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
Hi KC011
Please accept the response which address and meets your requirements so that the other community members will be helpful if they faces the similar issue.
Regards,
Community Support Team _ C Srikanth.
Hi lbendlin and v-csrikanth
I hope you're both doing well! I wanted to thank you again for the solution you provided earlier – everything is working perfectly now, and I’m happy with the results of the data model.
I have a follow-up question regarding the same dataset and was wondering if it’s possible to provide additional feedback on this or if I need to post a new question instead. I’m looking to assign certain data to each pen based on the Dimension Table. I’ve created separate tables for each type of data but I’m uncertain how to establish the relationship with the rest of the data.
Any guidance on how to approach this would be greatly appreciated.
Thanks again for all your help!