cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Sam001
Frequent Visitor

Getting Cumulative monthly total Percentage

Hello,

 

I am trying to get monthly cummulative total %  from following data model.

 

IDStartDateCompleteDateStartedFlagCompletedFlag
1587510/10/2019 10
10385010/10/2019 10
1995910/10/2019 10
6231910/23/20198/6/201911
6369210/10/201910/18/201911
10201010/3/2019 10
3200510/4/2019 10
12386410/4/2019 10
4189710/4/2019 10
12386110/4/2019 10
1714710/4/201910/29/201911
3173110/2/201910/11/201911
5361410/4/201910/17/201911
12307610/16/2019 10
4586210/3/201910/11/201911
191910/4/201910/17/201911

 

Then need to get count of started and cummelative total of completed over the weeks from start date.

example of what I am trying to build would be similar to below.

 

Month# of StartedWeeks from StartDateCummlative Total # of CompleteCummlative % (Cumm#Complete/#ofStarted)
jan200100%
jan200253%
jan2003105%
jan20048040%
jan20059045%
jan200610050%
jan200710352%
jan200810553%
jan2001010653%
jan2001110854%
feb350110%
feb350293%
feb3503206%
feb3504257%
feb35053510%
feb35068925%
feb35079728%
feb350811132%
feb3501023166%
feb3501123968%
feb3501224069%

 

Can some one help with approaching this issue, I will later need to convert this ti line chart with weeks from start as x-axis.

 

Sample PBIX can be downloaded from here:

https://saxonypartners-my.sharepoint.com/:u:/p/subash_gautam/EclzYoHBliBEg44s8XED8wIBg4GZMRFU_l8bpq8...

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Re: Getting Cumulative monthly total Percentage

Hi @Sam001 ,

I'm not clear how to calculate "count of started". Can you please explain of the logic? For getting cumulative total monthly, I think you could reference my answer from the similar thread to have a try. 

https://community.powerbi.com/t5/Desktop/Cumulative-sum-that-resets-every-year/td-p/994086

 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Super User IV
Super User IV

Re: Getting Cumulative monthly total Percentage

@Sam001 , refer if this can help you

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...





Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
In case it does not help, please provide additional information and mark me with @
My Recent Blog -Week is not so Weak Proud to be a Super User! Connect on Linkedin


Community Support
Community Support

Re: Getting Cumulative monthly total Percentage

Hi @Sam001 ,

I'm not clear how to calculate "count of started". Can you please explain of the logic? For getting cumulative total monthly, I think you could reference my answer from the similar thread to have a try. 

https://community.powerbi.com/t5/Desktop/Cumulative-sum-that-resets-every-year/td-p/994086

 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Sam001
Frequent Visitor

Re: Getting Cumulative monthly total Percentage

@v-xuding-msft  Thanks Xue for your responce. The count of start is count of ID where started flag is 1 or Sum of started flag. Similarly cummulative monthly total is cummulative count of ID where completedflag is one or sum of CompletedFlag that was started on same month.

 

TIA

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors