Summing up everything that left after the end date to the last date

[m4xon]

Hello,

I am struggling with the following problem, I am trying to create a line visual where X axis is the week number and year and Y is number of that that week. Seems straightforward, but the problem arises in that the chart has to be limited from week-year to specific week-year and everything after that summed up to the last week. So for example everything after 202412 should be added to 202412

Data example (everything after week 5 2024 should be included in week5)

Task	Date	Week	Year
Task 18	18-Dec-23	52	2023
Task 25	18-Dec-23	52	2023
Task 30	18-Dec-23	52	2023
Task 31	18-Dec-23	52	2023
Task 39	18-Dec-23	52	2023
Task 48	18-Dec-23	52	2023
Task 123	18-Dec-23	52	2023
Task 124	18-Dec-23	52	2023
Task 134	18-Dec-23	52	2023
Task 135	18-Dec-23	52	2023
Task 138	18-Dec-23	52	2023
Task 150	18-Dec-23	52	2023
Task 155	18-Dec-23	52	2023
Task 166	18-Dec-23	52	2023
Task 185	18-Dec-23	52	2023
Task 186	18-Dec-23	52	2023
Task 190	18-Dec-23	52	2023
Task 192	18-Dec-23	52	2023
Task 195	18-Dec-23	52	2023
Task 206	18-Dec-23	52	2023
Task 305	18-Dec-23	52	2023
Task 306	18-Dec-23	52	2023
Task 309	18-Dec-23	52	2023
Task 324	18-Dec-23	52	2023
Task 333	18-Dec-23	52	2023
Task 342	18-Dec-23	52	2023
Task 356	18-Dec-23	52	2023
Task 362	18-Dec-23	52	2023
Task 366	18-Dec-23	52	2023
Task 370	18-Dec-23	52	2023
Task 430	18-Dec-23	52	2023
Task 433	18-Dec-23	52	2023
Task 434	18-Dec-23	52	2023
Task 437	18-Dec-23	52	2023
Task 438	18-Dec-23	52	2023
Task 439	18-Dec-23	52	2023
Task 455	18-Dec-23	52	2023
Task 467	18-Dec-23	52	2023
Task 499	18-Dec-23	52	2023
Task 520	18-Dec-23	52	2023
Task 528	18-Dec-23	52	2023
Task 562	18-Dec-23	52	2023
Task 595	18-Dec-23	52	2023
Task 599	18-Dec-23	52	2023
Task 600	18-Dec-23	52	2023
Task 602	18-Dec-23	52	2023
Task 603	18-Dec-23	52	2023
Task 606	18-Dec-23	52	2023
Task 615	18-Dec-23	52	2023
Task 622	18-Dec-23	52	2023
Task 625	18-Dec-23	52	2023
Task 632	18-Dec-23	52	2023
Task 677	18-Dec-23	52	2023
Task 680	18-Dec-23	52	2023
Task 691	18-Dec-23	52	2023
Task 726	18-Dec-23	52	2023
Task 777	18-Dec-23	52	2023
Task 780	18-Dec-23	52	2023
Task 789	18-Dec-23	52	2023
Task 792	18-Dec-23	52	2023
Task 793	18-Dec-23	52	2023
Task 804	18-Dec-23	52	2023
Task 805	18-Dec-23	52	2023
Task 806	18-Dec-23	52	2023
Task 808	18-Dec-23	52	2023
Task 811	18-Dec-23	52	2023
Task 819	18-Dec-23	52	2023
Task 825	18-Dec-23	52	2023
Task 826	18-Dec-23	52	2023
Task 857	18-Dec-23	52	2023
Task 861	18-Dec-23	52	2023
Task 862	18-Dec-23	52	2023
Task 886	18-Dec-23	52	2023
Task 887	18-Dec-23	52	2023
Task 888	18-Dec-23	52	2023
Task 890	18-Dec-23	52	2023
Task 891	18-Dec-23	52	2023
Task 892	18-Dec-23	52	2023
Task 929	18-Dec-23	52	2023
Task 944	18-Dec-23	52	2023
Task 947	18-Dec-23	52	2023
Task 949	18-Dec-23	52	2023
Task 953	18-Dec-23	52	2023
Task 954	18-Dec-23	52	2023
Task 956	18-Dec-23	52	2023
Task 1016	18-Dec-23	52	2023
Task 1024	18-Dec-23	52	2023
Task 1026	18-Dec-23	52	2023
Task 1045	18-Dec-23	52	2023
Task 1049	18-Dec-23	52	2023
Task 15	19-Dec-23	52	2023
Task 42	19-Dec-23	52	2023
Task 44	19-Dec-23	52	2023
Task 46	19-Dec-23	52	2023
Task 49	19-Dec-23	52	2023
Task 57	19-Dec-23	52	2023
Task 60	19-Dec-23	52	2023
Task 62	19-Dec-23	52	2023
Task 239	19-Dec-23	52	2023
Task 241	19-Dec-23	52	2023
Task 242	19-Dec-23	52	2023
Task 277	19-Dec-23	52	2023
Task 280	19-Dec-23	52	2023
Task 282	19-Dec-23	52	2023
Task 295	19-Dec-23	52	2023
Task 297	19-Dec-23	52	2023
Task 301	19-Dec-23	52	2023
Task 314	19-Dec-23	52	2023
Task 317	19-Dec-23	52	2023
Task 321	19-Dec-23	52	2023
Task 330	19-Dec-23	52	2023
Task 335	19-Dec-23	52	2023
Task 340	19-Dec-23	52	2023
Task 345	19-Dec-23	52	2023
Task 346	19-Dec-23	52	2023
Task 352	19-Dec-23	52	2023
Task 354	19-Dec-23	52	2023
Task 375	19-Dec-23	52	2023
Task 378	19-Dec-23	52	2023
Task 384	19-Dec-23	52	2023
Task 392	19-Dec-23	52	2023
Task 393	19-Dec-23	52	2023
Task 395	19-Dec-23	52	2023
Task 398	19-Dec-23	52	2023
Task 400	19-Dec-23	52	2023
Task 402	19-Dec-23	52	2023
Task 403	19-Dec-23	52	2023
Task 405	19-Dec-23	52	2023
Task 406	19-Dec-23	52	2023
Task 407	19-Dec-23	52	2023
Task 408	19-Dec-23	52	2023
Task 409	19-Dec-23	52	2023
Task 410	19-Dec-23	52	2023
Task 411	19-Dec-23	52	2023
Task 412	19-Dec-23	52	2023
Task 413	19-Dec-23	52	2023
Task 414	19-Dec-23	52	2023
Task 415	19-Dec-23	52	2023
Task 417	19-Dec-23	52	2023
Task 418	19-Dec-23	52	2023
Task 424	19-Dec-23	52	2023
Task 462	19-Dec-23	52	2023
Task 464	19-Dec-23	52	2023
Task 497	19-Dec-23	52	2023
Task 498	19-Dec-23	52	2023
Task 509	19-Dec-23	52	2023
Task 515	19-Dec-23	52	2023
Task 521	19-Dec-23	52	2023
Task 568	19-Dec-23	52	2023
Task 593	19-Dec-23	52	2023
Task 596	19-Dec-23	52	2023
Task 640	19-Dec-23	52	2023
Task 678	19-Dec-23	52	2023
Task 711	19-Dec-23	52	2023
Task 712	19-Dec-23	52	2023
Task 727	19-Dec-23	52	2023
Task 738	19-Dec-23	52	2023
Task 750	19-Dec-23	52	2023
Task 751	19-Dec-23	52	2023
Task 759	19-Dec-23	52	2023
Task 766	19-Dec-23	52	2023
Task 767	19-Dec-23	52	2023
Task 773	19-Dec-23	52	2023
Task 776	19-Dec-23	52	2023
Task 784	19-Dec-23	52	2023
Task 786	19-Dec-23	52	2023
Task 794	19-Dec-23	52	2023
Task 795	19-Dec-23	52	2023
Task 798	19-Dec-23	52	2023
Task 801	19-Dec-23	52	2023
Task 802	19-Dec-23	52	2023
Task 807	19-Dec-23	52	2023
Task 809	19-Dec-23	52	2023
Task 810	19-Dec-23	52	2023
Task 822	19-Dec-23	52	2023
Task 824	19-Dec-23	52	2023
Task 1028	19-Dec-23	52	2023
Task 1040	19-Dec-23	52	2023
Task 1041	19-Dec-23	52	2023
Task 1054	19-Dec-23	52	2023
Task 1055	19-Dec-23	52	2023
Task 1059	19-Dec-23	52	2023
Task 32	20-Dec-23	52	2023
Task 236	20-Dec-23	52	2023
Task 268	20-Dec-23	52	2023
Task 271	20-Dec-23	52	2023
Task 279	20-Dec-23	52	2023
Task 332	20-Dec-23	52	2023
Task 472	20-Dec-23	52	2023
Task 506	20-Dec-23	52	2023
Task 530	20-Dec-23	52	2023
Task 549	20-Dec-23	52	2023
Task 552	20-Dec-23	52	2023
Task 578	20-Dec-23	52	2023
Task 685	20-Dec-23	52	2023
Task 693	20-Dec-23	52	2023
Task 739	20-Dec-23	52	2023
Task 775	20-Dec-23	52	2023
Task 1036	20-Dec-23	52	2023
Task 246	21-Dec-23	52	2023
Task 261	21-Dec-23	52	2023
Task 293	21-Dec-23	52	2023
Task 483	21-Dec-23	52	2023
Task 557	21-Dec-23	52	2023
Task 788	21-Dec-23	52	2023
Task 11	22-Dec-23	52	2023
Task 196	22-Dec-23	52	2023
Task 202	22-Dec-23	52	2023
Task 803	22-Dec-23	52	2023
Task 812	22-Dec-23	52	2023
Task 816	22-Dec-23	52	2023
Task 820	22-Dec-23	52	2023
Task 921	28-Dec-23	53	2023
Task 1043	28-Dec-23	53	2023
Task 5	02-Jan-24	01	2024
Task 7	02-Jan-24	01	2024
Task 10	02-Jan-24	01	2024
Task 200	02-Jan-24	01	2024
Task 381	02-Jan-24	01	2024
Task 388	02-Jan-24	01	2024
Task 394	02-Jan-24	01	2024
Task 396	02-Jan-24	01	2024
Task 419	02-Jan-24	01	2024
Task 420	02-Jan-24	01	2024
Task 421	02-Jan-24	01	2024
Task 493	02-Jan-24	01	2024
Task 496	02-Jan-24	01	2024
Task 560	02-Jan-24	01	2024
Task 896	02-Jan-24	01	2024
Task 899	02-Jan-24	01	2024
Task 902	02-Jan-24	01	2024
Task 916	02-Jan-24	01	2024
Task 917	02-Jan-24	01	2024
Task 918	02-Jan-24	01	2024
Task 920	02-Jan-24	01	2024
Task 958	02-Jan-24	01	2024
Task 960	02-Jan-24	01	2024
Task 1061	02-Jan-24	01	2024
Task 285	03-Jan-24	01	2024
Task 471	03-Jan-24	01	2024
Task 480	03-Jan-24	01	2024
Task 500	03-Jan-24	01	2024
Task 503	03-Jan-24	01	2024
Task 505	03-Jan-24	01	2024
Task 517	03-Jan-24	01	2024
Task 546	03-Jan-24	01	2024
Task 556	03-Jan-24	01	2024
Task 565	03-Jan-24	01	2024
Task 611	03-Jan-24	01	2024
Task 657	03-Jan-24	01	2024
Task 662	03-Jan-24	01	2024
Task 694	03-Jan-24	01	2024
Task 735	03-Jan-24	01	2024
Task 741	03-Jan-24	01	2024
Task 745	03-Jan-24	01	2024
Task 762	03-Jan-24	01	2024
Task 774	03-Jan-24	01	2024
Task 1064	03-Jan-24	01	2024
Task 33	04-Jan-24	01	2024
Task 341	04-Jan-24	01	2024
Task 399	04-Jan-24	01	2024
Task 401	04-Jan-24	01	2024
Task 814	04-Jan-24	01	2024
Task 984	04-Jan-24	01	2024
Task 985	04-Jan-24	01	2024
Task 267	05-Jan-24	01	2024
Task 753	05-Jan-24	01	2024
Task 965	05-Jan-24	01	2024
Task 966	05-Jan-24	01	2024
Task 983	05-Jan-24	01	2024
Task 97	08-Jan-24	02	2024
Task 513	08-Jan-24	02	2024
Task 553	08-Jan-24	02	2024
Task 561	08-Jan-24	02	2024
Task 243	09-Jan-24	02	2024
Task 21	12-Jan-24	02	2024
Task 100	15-Jan-24	03	2024
Task 490	16-Jan-24	03	2024
Task 13	17-Jan-24	03	2024
Task 16	17-Jan-24	03	2024
Task 813	17-Jan-24	03	2024
Task 1030	17-Jan-24	03	2024
Task 230	19-Jan-24	03	2024
Task 994	19-Jan-24	03	2024
Task 659	22-Jan-24	04	2024
Task 264	23-Jan-24	04	2024
Task 682	23-Jan-24	04	2024
Task 734	23-Jan-24	04	2024
Task 85	25-Jan-24	04	2024
Task 478	26-Jan-24	04	2024
Task 522	26-Jan-24	04	2024
Task 797	26-Jan-24	04	2024
Task 1035	26-Jan-24	04	2024
Task 367	27-Jan-24	04	2024
Task 716	29-Jan-24	05	2024
Task 98	31-Jan-24	05	2024
Task 104	31-Jan-24	05	2024
Task 105	31-Jan-24	05	2024
Task 260	31-Jan-24	05	2024
Task 327	02-Feb-24	05	2024
Task 349	02-Feb-24	05	2024
Task 577	02-Feb-24	05	2024
Task 778	05-Feb-24	06	2024
Task 274	06-Feb-24	06	2024
Task 1021	06-Feb-24	06	2024
Task 318	07-Feb-24	06	2024
Task 1002	07-Feb-24	06	2024
Task 257	08-Feb-24	06	2024
Task 1031	08-Feb-24	06	2024
Task 281	09-Feb-24	06	2024
Task 43	14-Feb-24	07	2024
Task 240	14-Feb-24	07	2024
Task 291	14-Feb-24	07	2024
Task 304	14-Feb-24	07	2024
Task 365	14-Feb-24	07	2024
Task 416	14-Feb-24	07	2024
Task 423	14-Feb-24	07	2024
Task 473	14-Feb-24	07	2024
Task 485	14-Feb-24	07	2024
Task 494	06-Mar-24	10	2024
Task 732	07-Mar-24	10	2024
Task 1062	12-Mar-24	11	2024
Task 262	19-Mar-24	12	2024
Task 700	20-Mar-24	12	2024
Task 699	22-Mar-24	12	2024

How to do that?

Thank you

Max

[v-jingzhan-msft]

Hi @m4xon 

Not sure how you decide the end year week. I assume that you want to use a slicer to switch the end yearweek. In this case, you can add a disconnected table that has yearweek column. Use this column in the slicer. 

Then create a measure to calculate the adjusted No. Assume that you want to calculate the No. of tasks in a week. 

Adjusted No. = 
VAR _endYearWeek = SELECTEDVALUE(YearWeek[YearWeek])
VAR _yearweek = SELECTEDVALUE('Table'[YearWeek])
RETURN
SWITCH(TRUE(),
_yearweek<_endYearWeek,COUNT('Table'[Task]),
_yearweek=_endYearWeek,CALCULATE(COUNT('Table'[Task]),ALLSELECTED('Table'[YearWeek]),'Table'[YearWeek]>=_endYearWeek),
BLANK()
)

Then you will have the outcome. The sample pbix is attached at bottom for your reference. 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

[m4xon]

Hello @v-jingzhan-msft, this looks very good, but I forgot to add that 'Adjusted No.' column should be a cumulative sum, is it possible to add it? 

[v-jingzhan-msft · Accepted solution]

Hi @m4xon 

'Adjusted No.' should be cumulative of what? You see in my sample it's calculating something like Count of tasks. Do you hope to calculate the cumulative sum of these Count numbers? If so, you can try 

Adjusted No. = 
VAR _endYearWeek = SELECTEDVALUE(YearWeek[YearWeek])
VAR _yearweek = SELECTEDVALUE('Table'[YearWeek])
RETURN
SWITCH(TRUE(),
_yearweek<_endYearWeek,CALCULATE(COUNT('Table'[Task]),ALLSELECTED('Table'[YearWeek]),'Table'[YearWeek]<=_yearweek),
_yearweek=_endYearWeek,CALCULATE(COUNT('Table'[Task]),ALLSELECTED('Table'[YearWeek])),
BLANK()
)

You can modify the COUNT section per your need. 

If this doesn't help, please provide more details about this question. Thanks. 

Best Regards,
Jing