DATESINPERIOD Measure Problem

[fedeleu]

Hi,

I have a model with 3 measures thats works OK. This is a table that shows measures values.

where measure_3 = measure_1 * measure_2

I must calculate the accumulated value at 12 months.

I created measure_4=Calculate (measure_3,DATESINPERIOD(Calendar[Date],Max(Calendar[Date]),-1,YEAR), but I did not get the expected values.

This is a table with expected vs obtained values.

Can someone tell me where is the mistake I am making?

Regards,

Federico

[Anonymous · Accepted solution]

Hi  @fedeleu ,

Here are the steps you can follow：

1. Create measure.

Measure =
SUMX(FILTER(ALL('Table'),'Table'[Date]<=MAX('Table'[Date])&&'Table'[Date]>DATE(YEAR(MAX('Table'[Date]))-1,MONTH(MAX('Table'[Date])),DAY(MAX('Table'[Date])))),[Measure_3])

flag =
var _min=MINX(ALL('Table'),'Table'[Date])
return
IF(_min<=MAX('Table'[Date])&&MAX('Table'[Date])>=DATE(YEAR(_min)+1,MONTH(_min),DAY(_min)),1,0)

2. Place [Flag] in Filter and set is = 1.

3. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly