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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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
v-xuding-msft
Community Support
Community Support

Hi @Anonymous ,

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
v-xuding-msft
Community Support
Community Support

Hi @Anonymous ,

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.
Anonymous
Not applicable

@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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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