How do I get to this final table?

Question

Hi&nbsp;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:&nbsp;Name+Country ConcatenateService RequiredWFRegistrations.Status1GDD Ltd-GermanyAnnual Return&nbsp;1GDD Ltd-Germany&nbsp;&nbsp;1GDD Ltd-GermanyVat RegistrationRegistered1GDD Ltd-GermanyVAT Return&nbsp;2BECOMMERCE LIMITED-GermanyAnnual Return&nbsp;2BECOMMERCE LIMITED-Germany&nbsp;&nbsp;2BECOMMERCE LIMITED-GermanyVat RegistrationWork-In-Progress2BECOMMERCE LIMITED-GermanyVAT Return&nbsp;3Kamido Katarzyna Szklanko-Pawlic-ItalyAnnual Return&nbsp;3Kamido Katarzyna Szklanko-Pawlic-FranceVat RegistrationRegistered3Kamido Katarzyna Szklanko-Pawlic-ItalyVat RegistrationRegistered3Kamido Katarzyna Szklanko-Pawlic-UnitedKingdomVat RegistrationRegistered&nbsp;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".&nbsp;&nbsp;Desired Table:&nbsp;&nbsp;&nbsp;Name+Country ConcatenateService RequiredWFRegistrations.StatusStatus of Booking1GDD Ltd-GermanyAnnual Return&nbsp;Registered1GDD Ltd-Germany&nbsp;&nbsp;Registered1GDD Ltd-GermanyVat RegistrationRegisteredRegistered1GDD Ltd-GermanyVAT Return&nbsp;Registered2BECOMMERCE LIMITED-GermanyAnnual Return&nbsp;Work-In-Progress2BECOMMERCE LIMITED-Germany&nbsp;&nbsp;Work-In-Progress2BECOMMERCE LIMITED-GermanyVat RegistrationWork-In-ProgressWork-In-Progress2BECOMMERCE LIMITED-GermanyVAT Return&nbsp;Work-In-Progress3Kamido Katarzyna Szklanko-Pawlic-ItalyAnnual Return&nbsp;Registered3Kamido Katarzyna Szklanko-Pawlic-FranceVat RegistrationRegisteredRegistered3Kamido Katarzyna Szklanko-Pawlic-ItalyVat RegistrationRegisteredRegistered3Kamido Katarzyna Szklanko-Pawlic-UnitedKingdomVat RegistrationRegisteredRegistered&nbsp;Thank you&nbsp;&nbsp;

v-piga-msft · Accepted Answer

Hi&nbsp;united2win&nbsp;,
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&nbsp; Regards,
Cherry

Forum Discussion

How do I get to this final table?

1 Reply

Related content

Matrix table

Lakehouse Table Generate Create Table

Tables combine

Table Transformation

Finding Final amount Current Month ?

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

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