Merge date dependant

[Anonymous]

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

[v-lili6-msft · Accepted solution]

hi, @Anonymous 

Sample data and expected output would help tremendously. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best Regards,

Lin

[Anonymous]

Ok, you right