RESULTS FROM ANOTHER TABLE

[TVARELA]

Hello all,

I want to do this calculated column: Reservations_with_card = If(stay_date < Action_date, "No_card,"with_card")
I have 2 tables:

First_table: Stay_data/Cod_client

Second_table: Action_date/Cod_client

Howerver i have repeted clients in both table (i don't know if that is an issue)

How can i have a result like this:

Cod_client/stay_date/"with_card"

Cod_client/stay_date/"no_card"

Cod_client/stay_date/"no_card"

Cod_client/stay_date/"with_card"

...

Thanks for your help

Tiago

[TVARELA · Accepted solution]

Table A

Stay Date	Hotel	Cod_cliente
01/01/2023	XXX	123456
01/01/2023	XXX	321654
02/01/2023	XXX	564231
02/01/2023	XXX	357951

Table B

Action date	Cod client	Card name
03/01/2023	123456	star
03/01/2023	321654	star
25/12/2022	564231	star
25/12/2022	357951	premium

Result table i need

Stay date	Cod client	With/whitout card
01/01/2023	123456	whitout card
01/01/2023	321654	whitout card
02/01/2023	564231	whith card
02/01/2023	357951	whith card

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[TVARELA · Accepted solution]

Table A

Stay Date	Hotel	Cod_cliente
01/01/2023	XXX	123456
01/01/2023	XXX	321654
02/01/2023	XXX	564231
02/01/2023	XXX	357951

Table B

Action date	Cod client	Card name
03/01/2023	123456	star
03/01/2023	321654	star
25/12/2022	564231	star
25/12/2022	357951	premium

Result table i need

Stay date	Cod client	With/whitout card
01/01/2023	123456	whitout card
01/01/2023	321654	whitout card
02/01/2023	564231	whith card
02/01/2023	357951	whith card

[lbendlin · Accepted solution]