Forum Discussion

fedeleu's avatar
fedeleu
Frequent Visitor
4 years ago
Solved

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 m...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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