Hola Comunidad... he estado utilizando este dax para calcular la pendiente (como en excel) para distintos valores(Y) en distintas fechas (X).... pero no me da lo mismo que excel.
La formula en excel es : =-PENDIENTE(S1196:S1214;$F1196:$F1214)*365.4
La formula Dax es:
Tasa Desgaste Variable =
VAR Known =
FILTER (
SELECTCOLUMNS (
ALLSELECTED ( 'BD'[X] ),
"Known[X]", ('BD'[X]),
"Known[Y]", MAX('BD'[Y])
),
AND (
NOT ( ISBLANK ( Known[X] ) ),
NOT ( ISBLANK ( Known[Y] ) )
)
)
VAR Count_Items =
COUNTROWS ( Known )
VAR Sum_X =
SUMX ( Known, Known[X] )
VAR Sum_X2 =
SUMX ( Known, Known[X] ^ 2 )
VAR Sum_Y =
SUMX ( Known, Known[Y] )
VAR Sum_XY =
SUMX ( Known, Known[X] * Known[Y] )
VAR Average_X =
AVERAGEX ( Known, Known[X] )
VAR Average_Y =
AVERAGEX ( Known, Known[Y] )
VAR Slope =
DIVIDE (
Count_Items * Sum_XY - Sum_X * Sum_Y,
Count_Items * Sum_X2 - Sum_X ^ 2
)
VAR Intercept =
Average_Y - Slope * Average_X
RETURN
SUMX (
DISTINCT ( 'BD'[X] ),
Intercept + Slope * 'BD'[X]
)/365.4
