Forum Discussion
Tableau to DAX code
Can anyone help in converting this code to DAX? S = ABS([x]-LOOKUP([x],-1))/ ( SQRT ( ABS(((([y] + LOOKUP([y],-1))/(SUM([z])+LOOKUP(SUM([z]), - 1)]))) * (1-(([y] + LOOKUP([y],-1))/(SUM([z])...
Here S (col. highlighted in yellow) is the desired result which ia the significance t-testing forumula.
The table has 3 data points from 2019 to 2021.
x is in percentage, whereas y and z are weigted and unweighted counts of respective years.