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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Percentage sum for rolling 12 months

Hi All,

Hope someone can me with this task please.

 

Employee = COUNTROWS ( factTable )

Starters = CALCULATE ( [Employee], USERELATIONSHIP ( factTable[StartDateKey, Date[DateKey ) )

After adding the above 2 measures to a table...

 

YearMonthStartersEmployees
2017Jun27840
2017Jul32798
2017Aug45825
2017Sep110798
2017Oct67987
2017Nov37798
2017Dec47679
2018Jan144790
2018Feb64810
2018Mar32904
2018Apr94802
2018May140916
2018Jun160789
2018Jul158910
2018Aug96844
2018Sep160828
2018Oct144844
2018Nov96844
2018Dec48844
2019Jan80844
2019Feb32815
2019Mar16844
2019Apr32828
2019May48844
2019Jun32844
2019Jul80844

 

and I want to get the SUM of percentages of (starters / employees) for the last 12 months on any given month selected from a slicer on the report. The result should look something like this but the Rolling 12 months % sum will be displayed in a card on the report, not in a table like this.

 

yearmonthstartersemployees% startersRolling 12 months % sum
2017Jun278403.21% 
2017Jul327984.01% 
2017Aug458255.45% 
2017Sep11079813.78% 
2017Oct679876.79% 
2017Nov377984.64% 
2017Dec476796.92% 
2018Jan14479018.23% 
2018Feb648107.90% 
2018Mar329043.54% 
2018Apr9480211.72% 
2018May14091615.28% 
2018Jun16078920.28% 
2018Jul15891017.36%131.90%
2018Aug9684411.37% 
2018Sep16082819.32% 
2018Oct14484417.06% 
2018Nov9684411.37% 
2018Dec488445.69% 
2019Jan808449.48% 
2019Feb328153.93% 
2019Mar168441.90% 
2019Apr328283.86% 
2019May488445.69% 
2019Jun328443.79% 
2019Jul808449.48%102.94%

 

Thank you.

0 REPLIES 0

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.