Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Merge date dependant

Hello
I have two tables:
- one with rooms planning for each customer (hotel for example), with a room ID
- one with rooms informations: number, level, number of beds. For each room this informations could change
Each days. There's two columns begin and end date related to room informations and room ID

If i only link room ID for the tables i duplicate datas with merge (left join)
I need to know with room informations are related to room customer datas of first table

How could we manage that with powerbi please because i don't find any solution?

Best regards

Mostal