Forum Discussion
Analitika
Post Prodigy
Post ProdigyTable contains a date column and several columns with headers as dates
Hi, I have one table looks like this: marked date column And two other tables: I tried to merge these two tables to main table and got more columns with their header...
Hi Analitika,
I'd like to suggest you do unpivot columns on these table date fields, then you can concatenate 'unique id' and 'date value' as keys to creating relationships between these tables.
Unpivot columns - Power Query | Microsoft Docs
How to Join Many to Many with a Bridge Table in Power BI | Seer Interactive
Regards,
Xiaoxin Sheng
Hi Analitika,
I'd like to suggest you do unpivot columns on these table date fields, then you can concatenate 'unique id' and 'date value' as keys to creating relationships between these tables.
Unpivot columns - Power Query | Microsoft Docs
How to Join Many to Many with a Bridge Table in Power BI | Seer Interactive
Regards,
Xiaoxin Sheng