Sum of remaining distinct values

[Austinehype]

Hi

I need a measure or calculated column that sum up the remaining month for example below

We are now in December and 3 months left for this fiscal year if I sum 3+2+1= 6 in December

In January it should be sum 2+1=3

In February it should be sum 1

FY begins in April and ends in March

Month	Month left
December	3
December	3
Jan	2
Jan	2
Feb	1
Feb	1
March	0

[Anonymous · Accepted solution]

Hi @Austinehype ,

Create a new table like below and create a relationship between table1 and table2.

Then create a measure.

Measure = CALCULATE(SUM('Table 2'[Month left]),FILTER(ALL('Table'),'Table'[Month left]<MIN('Table'[Month left])+1))

Result would be shown as below.

Best Regards,

Jay