How do I get to this final table?

[united2win]

Hi

I have the below table which is a mix of the client / country / service required / and a Reg.status of service required when VAT Registration:

Name+Country Concatenate	Service Required	WFRegistrations.Status
1GDD Ltd-Germany	Annual Return
1GDD Ltd-Germany
1GDD Ltd-Germany	Vat Registration	Registered
1GDD Ltd-Germany	VAT Return
2BECOMMERCE LIMITED-Germany	Annual Return
2BECOMMERCE LIMITED-Germany
2BECOMMERCE LIMITED-Germany	Vat Registration	Work-In-Progress
2BECOMMERCE LIMITED-Germany	VAT Return
3Kamido Katarzyna Szklanko-Pawlic-Italy	Annual Return
3Kamido Katarzyna Szklanko-Pawlic-France	Vat Registration	Registered
3Kamido Katarzyna Szklanko-Pawlic-Italy	Vat Registration	Registered
3Kamido Katarzyna Szklanko-Pawlic-UnitedKingdom	Vat Registration	Registered

I want to create a new column of "Status of Booking" that somehow looks like below. Where it populates the registrations.status for all services required where a VAT Registration is found that matches the other "Name+Country Concatenate". 

Desired Table:
Name+Country Concatenate	Service Required	WFRegistrations.Status	Status of Booking
1GDD Ltd-Germany	Annual Return		Registered
1GDD Ltd-Germany			Registered
1GDD Ltd-Germany	Vat Registration	Registered	Registered
1GDD Ltd-Germany	VAT Return		Registered
2BECOMMERCE LIMITED-Germany	Annual Return		Work-In-Progress
2BECOMMERCE LIMITED-Germany			Work-In-Progress
2BECOMMERCE LIMITED-Germany	Vat Registration	Work-In-Progress	Work-In-Progress
2BECOMMERCE LIMITED-Germany	VAT Return		Work-In-Progress
3Kamido Katarzyna Szklanko-Pawlic-Italy	Annual Return		Registered
3Kamido Katarzyna Szklanko-Pawlic-France	Vat Registration	Registered	Registered
3Kamido Katarzyna Szklanko-Pawlic-Italy	Vat Registration	Registered	Registered
3Kamido Katarzyna Szklanko-Pawlic-UnitedKingdom	Vat Registration	Registered	Registered

Thank you

[v-piga-msft · Accepted solution]

Hi @united2win ,

For your requirement, you could try the calculated column below.

Column = CALCULATE(MAX('Table'[WFRegistrations.Status]),ALLEXCEPT('Table','Table'[Name+Country Concatenate]))

Here is the output.

Best  Regards,

Cherry