Which date achieve 50%

Question

Hello&nbsp;I need help with one measure.&nbsp;I have a file with Customer Name , CUID (unique entity project number) and another column called&nbsp;'Actual/Schedule Go Live date format&nbsp;&nbsp;Active total column is showing Active CUIDS / Total CUIDs&nbsp;the idea would be using the total CUIDs (total projects for a specific customer) , the Live CUIDs and using the Actual GLD as Date, when are we going to reach the 50%.&nbsp;Example: Customer Below has 10 CUIDsCurrently 6 CUids are Live but the 50% was with CUID number 5 and date was 2023-05-01&nbsp;columns should show date: 2023-05-01 as the date we will reach 50% for this customer.&nbsp;CustomerCUIDCountry Long NameStatusActual/Schedule Go Live&nbsp;Customer A1001213BE01BelgiumLive2023-01-02&nbsp;Customer A1001213CH01SwitzerlandLive2023-01-02&nbsp;Customer A1001213IT01ItalyLive2023-03-01&nbsp;Customer A1001213NL01NetherlandsLive2023-03-01&nbsp;Customer A1001213GB01United kingdomLive2023-05-0150%Customer A1001213IE01IrelandLive2023-12-01&nbsp;Customer A1001213DE01GermanyUnder Implementation2024-06-03&nbsp;Customer A1001213GR01GreeceOn hold3000-12-01&nbsp;Customer A1001213PT01PortugalOn hold3000-12-01&nbsp;Customer A1001213RO01RomaniaOn hold3000-12-01&nbsp;&nbsp;thanks,&nbsp;&nbsp;&nbsp;

amitchandak · Accepted Answer

romovaro, Try window function can help
Power BI Window: Pareto Analysis Again, 80% of sales, Order by Measure when REL position is used: https://youtu.be/GpoITi_tRIw

Forum Discussion

Which date achieve 50%

2 Replies

Related content

TOP Achiever Analysis

Percentage achievement

Comparing Quarterly budgets to actual achievement

Find Most Recent Date Relative to another Date Column in Power Query

Can Microsoft Fabric achieve this?

Customer	CUID	Country Long Name	Status	Actual/Schedule Go Live
Customer A	1001213BE01	Belgium	Live	2023-01-02
Customer A	1001213CH01	Switzerland	Live	2023-01-02
Customer A	1001213IT01	Italy	Live	2023-03-01
Customer A	1001213NL01	Netherlands	Live	2023-03-01
Customer A	1001213GB01	United kingdom	Live	2023-05-01	50%
Customer A	1001213IE01	Ireland	Live	2023-12-01
Customer A	1001213DE01	Germany	Under Implementation	2024-06-03
Customer A	1001213GR01	Greece	On hold	3000-12-01
Customer A	1001213PT01	Portugal	On hold	3000-12-01
Customer A	1001213RO01	Romania	On hold	3000-12-01