Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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