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 DanH1995,
Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Hi Anonymous , sure, please follow the link below. I have created a sample report and included two source files.
Power BI Sample File
Thanks,
Dan
HI DanH1995,
I can't view the sample data, to required to sign in account for the following operations.
Can you please fix that link or create some dummy data and paste it here in table format in your threads? Then we can copy and test locally.
Notice: please remove sensitive data before sharing.
Regards,
Xiaoxin Sheng
Hi Anonymous ,
Sure, please see sample data below:
Table 1item 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