Trend down analysis

Hi, nagoor 

I recreated my measures. I tried to make the measures as reusable as possible.
Here are my measures:

30daysTable:

_30daysTable = 
var _30day=[_maxDate]-1
var _t=ADDCOLUMNS('Table',"maxdate",[_maxDate])
var _t1=
    FILTER(
        FILTER(_t,'Table'[Product Name]="AA1"),
        'Table'[Date]<=_30day&&'Table'[Date]>=_30day-30)
//==========================================================
var _t2=
    FILTER(
        FILTER(_t,'Table'[Product Name]="AA2"),
        'Table'[Date]<=_30day&&'Table'[Date]>=_30day-30)
//==========================================================
// if there are more product, _t3..._tn
var _tt=UNION(_t1,_t2)
// union(t1,t2....tn)
return _tt

Median, ABS, The value of lastest date, Thredshold, Result:

The above 5 measures are reusable parts, only need to change keywords to become the value of another indicator.
I will not expand it here because it contains a long code, please see the attachment for details.

The part that needs to be modified I include it with an equal line.

eg:

Result:

The reusable part, I've considered whether to implement it with a calculation group, but unfortunately the tabular editor doesn't work on my machine. Maybe you can go ahead and implement it.

Please refer to the attachment below for details. Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.