Forum Discussion
Anonymous
7 years agoNot applicable
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
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
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
2 Replies
- v-lili6-msftCommunity Support
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
- AnonymousNot applicableOk, you right