Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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
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
User | Count |
---|---|
15 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
17 | |
11 | |
5 | |
4 | |
3 |