Multiple relations in table

Hi Anonymous ,

Thanks for reaching out to us.

To address your requirement, it is suggested to creating a bridge table that maps each date period and start date to the individual dates within that period. Using DAX measures, you can dynamically filter and aggregate data, allowing the trend chart to display metrics for each date within the selected period.

This approach avoids duplicating tables and keeps the data model efficient.

If you still have any doubts, it would be best to provide some sample data and the expected results. This will help us understand your requirements more clearly and offer a more precise solution.

Best Regards,
Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly