Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
User | Count |
---|---|
89 | |
85 | |
66 | |
62 | |
57 |
User | Count |
---|---|
138 | |
112 | |
94 | |
82 | |
71 |