Forum Discussion
Forecasting two tables & multiple date fields with one slicer
Hello, I am looking for some guidance as to whether what I want to achieve is possible or not. I have two matrices in my report, both of which categorise each item in the table as to which suppor...
Hi Anonymous ,
Sure, please see sample data below:
Table 1
| item | u_eol_eos | u_eol_eos.u_eos | u_eol_eos.u_eoes | u_eol_eos.u_eol | u_private_iaas |
| testrecord1 | Version 1 | 12/07/2010 23:00 | 13/07/2015 23:00 | 13/07/2015 23:00 | FALSE |
| testrecord2 | Version 1 | 12/07/2010 23:00 | 13/07/2015 23:00 | 13/07/2015 23:00 | FALSE |
| testrecord3 | Version 1 | 12/07/2010 23:00 | 13/07/2015 23:00 | 13/07/2015 23:00 | FALSE |
| testrecord4 | Version 1 | 12/07/2010 23:00 | 13/07/2015 23:00 | 13/07/2015 23:00 | FALSE |
| testrecord5 | Version 2 | 12/01/2015 23:00 | 13/01/2020 23:00 | 09/01/2023 23:00 | FALSE |
| testrecord6 | Version 2 | 12/01/2015 23:00 | 13/01/2020 23:00 | 09/01/2023 23:00 | FALSE |
| testrecord7 | Version 2 | 12/01/2015 23:00 | 13/01/2020 23:00 | 09/01/2023 23:00 | FALSE |
| testrecord8 | Version 3 | 08/10/2018 23:00 | 09/10/2023 23:00 | 09/10/2023 23:00 | FALSE |
| testrecord9 | Version 3 | 08/10/2018 23:00 | 09/10/2023 23:00 | 09/10/2023 23:00 | FALSE |
| testrecord10 | Version 3 | 08/10/2018 23:00 | 09/10/2023 23:00 | 09/10/2023 23:00 | FALSE |
| testrecord11 | Version 3 | 08/10/2018 23:00 | 09/10/2023 23:00 | 09/10/2023 23:00 | FALSE |
| testrecord12 | Version 4 | 10/01/2022 23:00 | 11/01/2027 23:00 | 11/01/2027 23:00 | TRUE |
| testrecord13 | Version 4 | 10/01/2022 23:00 | 11/01/2027 23:00 | 11/01/2027 23:00 | TRUE |
| testrecord14 | Version 5 | 08/01/2024 23:00 | 08/01/2029 23:00 | 08/01/2029 23:00 | TRUE |
| testrecord15 | Version 5 | 08/01/2024 23:00 | 08/01/2029 23:00 | 08/01/2029 23:00 | TRUE |
| testrecord16 | Version 5 | 08/01/2024 23:00 | 08/01/2029 23:00 | 08/01/2029 23:00 | TRUE |
| testrecord17 | Version 5 | 08/01/2024 23:00 | 08/01/2029 23:00 | 08/01/2029 23:00 | TRUE |
| testrecord18 | Version 5 | 08/01/2024 23:00 | 08/01/2029 23:00 | 08/01/2029 23:00 | TRUE |
| testrecord19 | Version 6 | 12/10/2026 23:00 | 13/10/2031 23:00 | 13/10/2031 23:00 | TRUE |
| testrecord20 | Version 6 | 12/10/2026 23:00 | 13/10/2031 23:00 | 13/10/2031 23:00 | TRUE |
Table 2
| item | u_private_iaas | u_eol_eos | u_eol_eos.u_eos | u_eol_eos.u_eoes | u_eol_eos.u_eol |
| testrecord1 | FALSE | Version 1 | 11/07/2016 23:00 | 11/07/2016 23:00 | 11/07/2016 23:00 |
| testrecord1 | FALSE | Version 1 | 11/07/2016 23:00 | 11/07/2016 23:00 | 11/07/2016 23:00 |
| testrecord1 | FALSE | Version 1 | 11/07/2016 23:00 | 11/07/2016 23:00 | 11/07/2016 23:00 |
| testrecord1 | FALSE | Version 1 | 11/07/2016 23:00 | 11/07/2016 23:00 | 11/07/2016 23:00 |
| testrecord2 | FALSE | Version 2 | 08/07/2024 23:00 | 08/07/2024 23:00 | 08/07/2024 23:00 |
| testrecord2 | FALSE | Version 2 | 08/07/2024 23:00 | 08/07/2024 23:00 | 08/07/2024 23:00 |
| testrecord2 | FALSE | Version 2 | 08/07/2024 23:00 | 08/07/2024 23:00 | 08/07/2024 23:00 |
| testrecord2 | FALSE | Version 2 | 08/07/2024 23:00 | 08/07/2024 23:00 | 08/07/2024 23:00 |
| testrecord2 | FALSE | Version 2 | 08/07/2024 23:00 | 08/07/2024 23:00 | 08/07/2024 23:00 |
| testrecord2 | FALSE | Version 2 | 08/07/2024 23:00 | 08/07/2024 23:00 | 08/07/2024 23:00 |
| testrecord2 | FALSE | Version 2 | 08/07/2024 23:00 | 08/07/2024 23:00 | 08/07/2024 23:00 |
| testrecord3 | FALSE | Version 2 | 08/07/2024 23:00 | 08/07/2024 23:00 | 08/07/2024 23:00 |
| testrecord3 | FALSE | Version 2 | 08/07/2024 23:00 | 08/07/2024 23:00 | 08/07/2024 23:00 |
| testrecord3 | FALSE | Version 2 | 08/07/2024 23:00 | 08/07/2024 23:00 | 08/07/2024 23:00 |
| testrecord3 | FALSE | Version 2 | 08/07/2024 23:00 | 08/07/2024 23:00 | 08/07/2024 23:00 |
| testrecord3 | FALSE | Version 2 | 08/07/2024 23:00 | 08/07/2024 23:00 | 08/07/2024 23:00 |
| testrecord3 | FALSE | Version 2 | 08/07/2024 23:00 | 08/07/2024 23:00 | 08/07/2024 23:00 |
| testrecord4 | FALSE | Version 3 | 10/10/2022 23:00 | 10/10/2022 23:00 | 10/10/2022 23:00 |
| testrecord4 | FALSE | Version 3 | 10/10/2022 23:00 | 10/10/2022 23:00 | 10/10/2022 23:00 |
| testrecord4 | FALSE | Version 3 | 10/10/2022 23:00 | 10/10/2022 23:00 | 10/10/2022 23:00 |
| testrecord5 | FALSE | Version 3 | 10/10/2022 23:00 | 10/10/2022 23:00 | 10/10/2022 23:00 |
| testrecord5 | FALSE | Version 3 | 10/10/2022 23:00 | 10/10/2022 23:00 | 10/10/2022 23:00 |
| testrecord5 | FALSE | Version 3 | 10/10/2022 23:00 | 10/10/2022 23:00 | 10/10/2022 23:00 |
| testrecord5 | FALSE | Version 3 | 10/10/2022 23:00 | 10/10/2022 23:00 | 10/10/2022 23:00 |
| testrecord6 | FALSE | Version 4 | 13/07/2026 23:00 | 13/07/2026 23:00 | 13/07/2026 23:00 |
| testrecord6 | FALSE | Version 4 | 13/07/2026 23:00 | 13/07/2026 23:00 | 13/07/2026 23:00 |
| testrecord7 | FALSE | Version 4 | 13/07/2026 23:00 | 13/07/2026 23:00 | 13/07/2026 23:00 |
| testrecord8 | FALSE | Version 4 | 13/07/2026 23:00 | 13/07/2026 23:00 | 13/07/2026 23:00 |
| testrecord9 | FALSE | Version 4 | 13/07/2026 23:00 | 13/07/2026 23:00 | 13/07/2026 23:00 |
| testrecord9 | FALSE | Version 4 | 13/07/2026 23:00 | 13/07/2026 23:00 | 13/07/2026 23:00 |
| testrecord9 | FALSE | Version 4 | 13/07/2026 23:00 | 13/07/2026 23:00 | 13/07/2026 23:00 |
| testrecord9 | FALSE | Version 4 | 13/07/2026 23:00 | 13/07/2026 23:00 | 13/07/2026 23:00 |
| testrecord9 | FALSE | Version 4 | 13/07/2026 23:00 | 13/07/2026 23:00 | 13/07/2026 23:00 |
| testrecord10 | FALSE | Version 5 | 06/01/2025 23:00 | 07/01/2030 23:00 | 07/01/2030 23:00 |
| testrecord10 | FALSE | Version 5 | 06/01/2025 23:00 | 07/01/2030 23:00 | 07/01/2030 23:00 |
| testrecord10 | FALSE | Version 5 | 06/01/2025 23:00 | 07/01/2030 23:00 | 07/01/2030 23:00 |
| testrecord10 | FALSE | Version 5 | 06/01/2025 23:00 | 07/01/2030 23:00 | 07/01/2030 23:00 |
| testrecord10 | FALSE | Version 5 | 06/01/2025 23:00 | 07/01/2030 23:00 | 07/01/2030 23:00 |
| testrecord11 | FALSE | Version 5 | 06/01/2025 23:00 | 07/01/2030 23:00 | 07/01/2030 23:00 |
| testrecord11 | FALSE | Version 5 | 06/01/2025 23:00 | 07/01/2030 23:00 | 07/01/2030 23:00 |
| testrecord12 | TRUE | Version 5 | 06/01/2025 23:00 | 07/01/2030 23:00 | 07/01/2030 23:00 |
| testrecord12 | TRUE | Version 5 | 06/01/2025 23:00 | 07/01/2030 23:00 | 07/01/2030 23:00 |
| testrecord13 | TRUE | Version 5 | 06/01/2025 23:00 | 07/01/2030 23:00 | 07/01/2030 23:00 |
| testrecord13 | TRUE | Version 5 | 06/01/2025 23:00 | 07/01/2030 23:00 | 07/01/2030 23:00 |
| testrecord14 | TRUE | Version 5 | 06/01/2025 23:00 | 07/01/2030 23:00 | 07/01/2030 23:00 |
| testrecord15 | TRUE | Version 5 | 06/01/2025 23:00 | 07/01/2030 23:00 | 07/01/2030 23:00 |
| testrecord16 | TRUE | Version 5 | 06/01/2025 23:00 | 07/01/2030 23:00 | 07/01/2030 23:00 |
| testrecord16 | TRUE | Version 5 | 06/01/2025 23:00 | 07/01/2030 23:00 | 07/01/2030 23:00 |
| testrecord16 | TRUE | Version 5 | 06/01/2025 23:00 | 07/01/2030 23:00 | 07/01/2030 23:00 |
HI DanH1995,
It seems like your table includes multiple date fields, perhaps you can unpivot these date fields to convert them to attribute an value. Then you can extract the value and use the calendar table to link these two table records:
Unpivot columns - Power Query | Microsoft Learn
How to Join Many to Many with a Bridge Table in Power BI | Seer Interactive
Regards,
Xiaoxin Sheng