Forum Discussion
DATESINPERIOD Measure Problem
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
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
1 Reply
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