Forum Discussion
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 headers as dates.
Therefore I can't implement right slicer of date. Because other column headers are dates.
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
1 Reply
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