Table contains a date column and several columns with headers as dates

[Analitika]

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.

[Anonymous · Accepted solution]

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