cumulative function over the last 12 months given a specific date

[Anonymous]

Hello,

I need to create a DAX measure to compute the total volume over the past 12 months from a specific date, cumulatively. This date is different for each user, and is represented in the LastProofOfFunds column.

[Anonymous · Accepted solution]

Hi @Anonymous ,

Do you have the date column and the corresponded volume value in the table? If so you could refer the following measure.

Total Volume = CALCULATE(SUM('Table'[Volume]),FILTER(ALLSELECTED('Table'),'Table'[date]<=SELECTEDVALUE('Table'[LastProofOfFunds ])&&'Table'[date]>=EDATE(SELECTEDVALUE('Table'[LastProofOfFunds ]),-12)))

Best Regards,

Jay

[ValtteriN]

Hi,

Here is an example.

Start data:

Dax:

RT12 = CALCULATE (

sum(RT12[Value]),

all(RT12[Date]),

DATESBETWEEN (

'RT12'[Date],

DATEADD (

LASTDATE ( DATEADD ( 'RT12'[Date], -12, MONTH ) ),

+1,

DAY

),

LASTDATE ( 'RT12'[Date] )

)

)

End result:

Hopefully this helps and if it does, consider accepting this as a solution!