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

Add Solution

Hi,

 

I have a Custum Colum that works out 15minute time window. if I use this Colum to break down one of my measures that shows a total number of successful discharges shipments. Which looks like this...

 

13:00:00234
13:15:001441
13:30:00741
13:45:00752
14:00:004242
14:15:00772
14:30:00244
14:45:002222
15:00:00444

 

Am not sure how to get this to add each Colum instead of showing totals per the breakdown of 15m, I need the totals to increase and add by the 15m window like this below.

 

13:00:000
13:15:00118
13:30:00737
13:45:001491
14:00:002330
14:15:003122
14:30:003906
14:45:005013
15:00:005988
15:15:007485
15:30:008873
15:45:0010171
16:00:0011601
16:15:0012997
16:30:0014495
16:45:0015782
17:00:0016958
17:15:0018193
17:30:0019433
17:45:0020873
18:00:0022486
18:15:0024076
18:30:0025257
18:45:0027029
19:00:0028422
19:15:0030151
19:30:0032943
19:45:0035743
20:00:0038538
20:15:0041514
20:30:0045017
20:45:0048832
21:00:0051744
21:15:0054054
21:30:0057370
21:45:0060516
22:00:0062417
22:15:0065542
22:30:0069334
22:45:0073194
23:00:0077062
23:15:0080707
23:30:0084414
23:45:0088218
00:00:0091733
00:15:0095459
00:30:0098769
00:45:00101533
01:00:00104706
01:15:00107461
01:30:00110317
01:45:00113420
02:00:00116661
02:15:00119153
02:30:00120695
02:45:00122326
03:00:00123863
03:15:00124767
03:30:00126427
03:45:00128345
04:00:00129667
04:15:00130057
04:30:00130658
04:45:00131257
05:00:00131931
05:15:00132125
05:30:00132160
05:45:00132160
06:00:00132160
06:15:00132160

 

I use this measure to drill down my total shipments:

 

CoyTotal = calculate (countrows(ItemTracking), search("R***C-Normal*", ItemTracking[Merged],, 0)>0) + calculate (countrows(ItemTracking), search("LD***-Normal", ItemTracking[Merged],, 0)>0) + calculate (countrows(ItemTracking), search("SPUD***-Normal*", ItemTracking[Merged],, 0)>0) + calculate (countrows(ItemTracking), search("SVC***-Normal", ItemTracking[Merged],, 0)>0) + calculate (countrows(ItemTracking), search("R*5*C-MAX_R*", ItemTracking[Merged],, 0)>0

 

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

its ok i managed to figure the cold out, but thnak you very much for taking the time to read my post.

 

Cumulative Total = CALCULATE( [CoyTotal], FILTER(ALLSELECTED( ItemTracking ), ItemTracking[CDATE] <= MAX( ItemTracking[CDATE] ) ) )

View solution in original post

2 REPLIES 2
v-yuta-msft
Community Support
Community Support

@Anonymous ,

 

"Am not sure how to get this to add each Colum instead of showing totals per the breakdown of 15m, I need the totals to increase and add by the 15m window like this below."

 

Could you share more details about the logic?

 

Community Support Team _ Jimmy Tao

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

Anonymous
Not applicable

its ok i managed to figure the cold out, but thnak you very much for taking the time to read my post.

 

Cumulative Total = CALCULATE( [CoyTotal], FILTER(ALLSELECTED( ItemTracking ), ItemTracking[CDATE] <= MAX( ItemTracking[CDATE] ) ) )

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.