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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Rosario
Helper I
Helper I

Percentage Retention

Hi, I need help please, I'm trying to get "Result expected" calculated from the table as shown below, ei; Year 2023 Column E / Year 2019 Column A =  101.27%:

 

YearABCDEFGHIJKLM
202323727225222723919120520719416113313399
202228026223123621420822120017114413910598
2021264237235212208222201189154161116109112
202023524120321622220818915616812611712187
20192361912042192121941651681351261299266
              
 2023E/2019A2023G/2019E2023M/2019I2012M/2019P         
Result expected101.27%96.70%73.33%76.74%         

 

Many thanks. Rosario.

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

Your expected results are inconsistent but here is one version

 

lbendlin_1-1701563174066.png

 

 

View solution in original post

2 REPLIES 2
lbendlin
Super User
Super User

Your expected results are inconsistent but here is one version

 

lbendlin_1-1701563174066.png

 

 

Hi, Thanks for your support, it helps for the first result. I know there are inconsistencies, and it was we really are after. You help gave me an idea on how to get the other reuslts. I will try and see if it works. Thank You. Rosario.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.