Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
romovaro
Responsive Resident
Responsive Resident

Which date achieve 50%

Hello

 

I need help with one measure.

 

I have a file with Customer Name , CUID (unique entity project number) and another column called 'Actual/Schedule Go Live date format

 

romovaro_0-1714401935503.png

 

Active total column is showing Active CUIDS / Total CUIDs

 

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%.

 

Example: Customer Below has 10 CUIDs

Currently 6 CUids are Live but the 50% was with CUID number 5 and date was 2023-05-01

 

columns should show date: 2023-05-01 as the date we will reach 50% for this customer.

 

CustomerCUIDCountry Long NameStatusActual/Schedule Go Live 
Customer A1001213BE01BelgiumLive2023-01-02 
Customer A1001213CH01SwitzerlandLive2023-01-02 
Customer A1001213IT01ItalyLive2023-03-01 
Customer A1001213NL01NetherlandsLive2023-03-01 
Customer A1001213GB01United kingdomLive2023-05-0150%
Customer A1001213IE01IrelandLive2023-12-01 
Customer A1001213DE01GermanyUnder Implementation2024-06-03 
Customer A1001213GR01GreeceOn hold3000-12-01 
Customer A1001213PT01PortugalOn hold3000-12-01 
Customer A1001213RO01RomaniaOn hold3000-12-01 

 

thanks,

 

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@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

Thanks. I will check. I do also have some pareto visuals but in this case I have thousands of customers = Pareto for each customer? for very customer I need to know when we reach the 50% of live entities vs Total entities...

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.