Commulative sum for continuous months but if there is no value in any month-sum to be started from 1

[RatanBhushan_05]

Hi Team

In my data set i am trying if for any month there is no number available - then commulative total needs to be started from 1 again.

Is there any way to sort this?

Country

Site

Measure

Jan-23

Feb-23

Mar-23

Apr-23

May-23

Jun-23

Jul-23

Aug-23

Sep-23

Oct-23

Nov-23

AUSTRALIA

AUS - ASQ - ASQUITH

AB

1

1

2

3

1

1

2

3

This should be the outcome, I can provide dataset if someone can help me into this.

Please.....

[RatanBhushan_05]

I am trying to put data here but its not showing, although I have posted numbers of times.,

[FreemanZ]

how about this:

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

[FreemanZ]

please don't hesitate to provide the dataset 

[RatanBhushan_05]

I have provided the dataset. Please help.

[RatanBhushan_05]

Region	Country	Site	Measure	Result	New_yearmon
APMEA	AUSTRALIA	AUS - WOD - WODONGA	AA	1	Jul-23
APMEA	AUSTRALIA	AUS - ASQ - ASQUITH	AA	1	Jan-23
APMEA	AUSTRALIA	AUS - ASQ - ASQUITH	AA	1	Feb-23
APMEA	AUSTRALIA	AUS - ASQ - ASQUITH	AA	1	Mar-23
APMEA	AUSTRALIA	AUS - ASQ - ASQUITH	AA	1	Apr-23
APMEA	AUSTRALIA	AUS - UBW - WACOL	AA	1	Mar-23
APMEA	AUSTRALIA	AUS - UBW - WACOL	AA	1	Apr-23
APMEA	AUSTRALIA	AUS - MCA - BALLARAT	AA	1	Jan-23
APMEA	AUSTRALIA	AUS - MCA - BALLARAT	AA	1	Feb-23
APMEA	AUSTRALIA	AUS - MCA - BALLARAT	AA	1	Mar-23
APMEA	AUSTRALIA	AUS - WOD - WODONGA	AB	1	Mar-23
APMEA	AUSTRALIA	AUS - WOD - WODONGA	AB	1	Apr-23
APMEA	AUSTRALIA	AUS - ASQ - ASQUITH	AB	1	Mar-23
APMEA	AUSTRALIA	AUS - UBW - WACOL	AB	1	Mar-23
APMEA	AUSTRALIA	AUS - UBW - WACOL	AB	1	May-23
APMEA	AUSTRALIA	AUS - MCA - BALLARAT	AB	1	Feb-23
APMEA	AUSTRALIA	AUS - MCA - BALLARAT	AB	1	Mar-23
APMEA	AUSTRALIA	AUS - ASQ - ASQUITH	AC	1	Apr-23
APMEA	AUSTRALIA	AUS - UBW - WACOL	AC	1	Jan-23
APMEA	AUSTRALIA	AUS - UBW - WACOL	AC	1	Feb-23
APMEA	AUSTRALIA	AUS - UBW - WACOL	AC	1	Apr-23
APMEA	AUSTRALIA	AUS - MCA - BALLARAT	AC	1	Feb-23
APMEA	AUSTRALIA	AUS - MCA - BALLARAT	AC	1	Mar-23
APMEA	AUSTRALIA	AUS - WOD - WODONGA	AC	1	Oct-23
APMEA	AUSTRALIA	AUS - MFA - WYONG	AD	1	Feb-23
APMEA	AUSTRALIA	AUS - UBW - WACOL	AD	1	Feb-23
APMEA	AUSTRALIA	AUS - UBW - WACOL	AD	1	Apr-23
APMEA	AUSTRALIA	AUS - UBW - WACOL	AD	1	Jun-23
APMEA	AUSTRALIA	AUS - UBW - WACOL	AD	1	Aug-23
APMEA	AUSTRALIA	AUS - MCA - BALLARAT	AD	1	Mar-23
APMEA	AUSTRALIA	AUS - WOD - WODONGA	AD	1	Mar-23
APMEA	AUSTRALIA	AUS - MFA - WYONG	AE	1	Feb-23
APMEA	AUSTRALIA	AUS - MFA - WYONG	AE	1	Oct-23
APMEA	AUSTRALIA	AUS - UBW - WACOL	AE	1	Mar-23
APMEA	AUSTRALIA	AUS - MCA - BALLARAT	AE	1	Mar-23

[RatanBhushan_05]

Country	Site	Measure	Result	YearMon
UK	GBR - WAL - WALTHAM	AB	1	Jan-23
UK	GBR - WAL - WALTHAM	AB	1	Feb-23
UK	GBR - WAL - WALTHAM	AB	1	Mar-23
UK	GBR - WAL - WALTHAM	AB	1	Apr-23
UK	GBR - WAL - WALTHAM	AB	1	May-23
UK	GBR - WAL - WALTHAM	AB	1	Jun-23
UK	GBR - WAL - WALTHAM	AB	1	Jul-23
UK	GBR - WAL - WALTHAM	AB	1	Aug-23
BELGIUM	BEL - BRU - BRUSSELS	AB	1	Jan-23
POLAND	POL - JAN - SOCHACZEW	AB	1	Feb-23
POLAND	POL - JAN - SOCHACZEW	AB	1	Mar-23
POLAND	POL - JAN - SOCHACZEW	AB	1	Apr-23
POLAND	POL - JAN - SOCHACZEW	AB	1	May-23
POLAND	POL - JAN - SOCHACZEW	AB	1	Jun-23
POLAND	POL - JAN - SOCHACZEW	AB	1	Jul-23
POLAND	POL - JAN - SOCHACZEW	AB	1	Oct-23
POLAND	POL - SOC - SOCHACZEW	AB	1	Feb-23
POLAND	POL - SOC - SOCHACZEW	AB	1	Mar-23
POLAND	POL - SOC - SOCHACZEW	AB	1	Apr-23
POLAND	POL - SOC - SOCHACZEW	AB	1	May-23
POLAND	POL - SOC - SOCHACZEW	AB	1	Jun-23
POLAND	POL - SOC - SOCHACZEW	AB	1	Jul-23
POLAND	POL - SOC - SOCHACZEW	AB	1	Oct-23
GERMANY	DEU - VSN - VIERSEN	AB	1	Jan-23
GERMANY	DEU - VSN - VIERSEN	AB	1	Feb-23
GERMANY	DEU - VSN - VIERSEN	AB	1	Apr-23
GERMANY	DEU - VSN - VIERSEN	AB	1	Jun-23
GERMANY	DEU - VSN - VIERSEN	AB	1	Jul-23
GERMANY	DEU - VSN - VIERSEN	AB	1	Aug-23
GERMANY	DEU - VSN - VIERSEN	AB	1	Sep-23
GERMANY	DEU - VSN - VIERSEN	AB	1	Oct-23
FRANCE	FRA - STD - SAINT DENIS L'HOTEL	AB	1	Jan-23
FRANCE	FRA - STD - SAINT DENIS L'HOTEL	AB	1	Feb-23
FRANCE	FRA - STD - SAINT DENIS L'HOTEL	AB	1	Mar-23
FRANCE	FRA - STD - SAINT DENIS L'HOTEL	AB	1	Apr-23
FRANCE	FRA - STD - SAINT DENIS L'HOTEL	AB	1	Jun-23
FRANCE	FRA - STD - SAINT DENIS L'HOTEL	AB	1	Sep-23
FRANCE	FRA - ERN - ERNOLSHEIM	AB	1	Jan-23
FRANCE	FRA - ERN - ERNOLSHEIM	AB	1	Feb-23
FRANCE	FRA - ERN - ERNOLSHEIM	AB	1	Mar-23
FRANCE	FRA - ERN - ERNOLSHEIM	AB	1	Apr-23
FRANCE	FRA - ERN - ERNOLSHEIM	AB	1	Aug-23
FRANCE	FRA - ERN - ERNOLSHEIM	AB	1	Sep-23
FRANCE	FRA - RCC - LES RUES DES VIGNES	AB	1	Feb-23
BELGIUM	BEL - OLN - OLEN	AB	1	Jan-23
FRANCE	FRA - CHD - CHATEAUDUN	AB	1	Jan-23
FRANCE	FRA - CHD - CHATEAUDUN	AB	1	May-23
FRANCE	FRA - CHD - CHATEAUDUN	AB	1	Jun-23
FRANCE	FRA - CHD - CHATEAUDUN	AB	1	Jul-23
UK	GBR - THO - BIRSTALL	AB	1	Jan-23
UK	GBR - RCS - YEOVIL_CASTLE CARY_SOMERSET	AB	1	Apr-23
UK	GBR - RCS - YEOVIL_CASTLE CARY_SOMERSET	AB	1	Jul-23
UK	GBR - RCS - YEOVIL_CASTLE CARY_SOMERSET	AB	1	Aug-23
UK	GBR - RCS - YEOVIL_CASTLE CARY_SOMERSET	AB	1	Sep-23
FRANCE	FRA - RCA - AIMARGUES	AB	1	Oct-23
GERMANY	DEU - MIN - MINDEN	AB	1	Jan-23
GERMANY	DEU - MIN - MINDEN	AB	1	Feb-23
GERMANY	DEU - MIN - MINDEN	AB	1	Mar-23
POLAND	POL - RNI - NIEPOLOMICE	AB	1	Apr-23
POLAND	POL - RNI - NIEPOLOMICE	AB	1	May-23
POLAND	POL - RNI - NIEPOLOMICE	AB	1	Jun-23
NETHERLANDS	NLD - OBL - BEIJERLAND - OUD	AB	1	Mar-23
NETHERLANDS	NLD - OBL - BEIJERLAND - OUD	AB	1	Apr-23
NETHERLANDS	NLD - OBL - BEIJERLAND - OUD	AB	1	May-23
NETHERLANDS	NLD - OBL - BEIJERLAND - OUD	AB	1	Jun-23
NETHERLANDS	NLD - OBL - BEIJERLAND - OUD	AB	1	Jul-23
NETHERLANDS	NLD - OBL - BEIJERLAND - OUD	AB	1	Oct-23
NETHERLANDS	NLD - OBL - BEIJERLAND - OUD	AB	1	Nov-23
SPAIN	ESP - ARV - AREVALO	AB	1	Jan-23
FRANCE	FRA - RHO - AIMARGUES	AB	1	Jan-23