Issue with Measure for Monthly cumulative calculation

Question

Hello,&nbsp;I have an issue displaying a measure as a monthly cumulative value relative to two date values.&nbsp;&nbsp;The data I'm working with is population values within a start and end date and by country:Organisation Namefinal_org_idStart_DateContract_Endcontract_idcountry_namepopulationABC Org3840032551/11/202231/10/2023384005431MYANMAR5ABC Org3840032551/02/202331/10/2023384005431MYANMAR5DEF Org3840033281/08/202231/07/2023384003928MYANMAR17GHI Org3840033301/07/202230/06/2023384004749MYANMAR4JKL Org3840084831/09/202231/08/2023384005132MYANMAR1MNO Org3840093221/08/202231/07/2023384005194MYANMAR3PQR Org3840096131/01/202331/01/2024384005926MYANMAR28&nbsp;And in some cases a single Org will have several changes in population within a single contract period:Organisation Namefinal_org_idStart_DateContract_Endcontract_idcountry_namepopulation123 Org3840079131/05/202230/04/2023384004452SINGAPORE1853123 Org3840079131/07/202230/04/2023384004452SINGAPORE2730123 Org3840079131/10/202230/04/2023384004452SINGAPORE3119123 Org3840079131/01/202330/04/2023384004452SINGAPORE3355123 Org3840079131/04/202330/04/2023384004452SINGAPORE3850&nbsp;This is my measure:Monthly Pop Total =VAR __month =&nbsp; &nbsp; STARTOFMONTH ( 'Calendar Reference'[Date].[Date] )RETURN&nbsp; &nbsp; CALCULATE (&nbsp; &nbsp; &nbsp; &nbsp; [Total Population],&nbsp; &nbsp; &nbsp; &nbsp; FILTER (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ORG_Pop_Data,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MAX ( ORG_Pop_Data[Effective_Date] ) &lt;= __month&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; ORG_Pop_Data[Contract_End].[Date] &gt;= __month&nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; ORG_Pop_Data[population]&nbsp; &nbsp; )&nbsp;And data model:&nbsp;Current output:I need to display the total population monthly by country.But how I want it to sum the population values is it should sum all Population by country where the month is &gt;= Start_Date and &lt;= Contract_End like below using the Myanmar data in the table above:&nbsp;2022&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2023&nbsp;&nbsp;&nbsp;JulyAugustSeptemberOctoberNovemberDecemberJanuaryFebruaryMarchMyanmar42425253030586363

anonymous · Accepted Answer

HI&nbsp;jason_beck14,
I'm not so clear how the&nbsp;‘Total Population’ expression calculated, can you please share some more detail about these?
How to Get Your Question Answered Quickly&nbsp;&nbsp;
In addition, you can also take a look to the Greg’s blog about analysis on start, end date range define by multiple date fields if hleps:
Before You Post, Read This: start, end date &nbsp;Regards,
Xiaoxin Sheng

Forum Discussion

Issue with Measure for Monthly cumulative calculation

1 Reply

Related content

Measure calculation of cumulative progress %

Cumulative Difference from Another measure

DAX Calculated Measure

Measure To Calculate Cumulative Percentage

Cumulative Measure

Organisation Name	final_org_id	Start_Date	Contract_End	contract_id	country_name	population
ABC Org	384003255	1/11/2022	31/10/2023	384005431	MYANMAR	5
ABC Org	384003255	1/02/2023	31/10/2023	384005431	MYANMAR	5
DEF Org	384003328	1/08/2022	31/07/2023	384003928	MYANMAR	17
GHI Org	384003330	1/07/2022	30/06/2023	384004749	MYANMAR	4
JKL Org	384008483	1/09/2022	31/08/2023	384005132	MYANMAR	1
MNO Org	384009322	1/08/2022	31/07/2023	384005194	MYANMAR	3
PQR Org	384009613	1/01/2023	31/01/2024	384005926	MYANMAR	28

	2022						2023
	July	August	September	October	November	December	January	February	March
Myanmar	4	24	25	25	30	30	58	63	63

Organisation Name	final_org_id	Start_Date	Contract_End	contract_id	country_name	population
123 Org	384007913	1/05/2022	30/04/2023	384004452	SINGAPORE	1853
123 Org	384007913	1/07/2022	30/04/2023	384004452	SINGAPORE	2730
123 Org	384007913	1/10/2022	30/04/2023	384004452	SINGAPORE	3119
123 Org	384007913	1/01/2023	30/04/2023	384004452	SINGAPORE	3355
123 Org	384007913	1/04/2023	30/04/2023	384004452	SINGAPORE	3850