Forum Discussion

pk1593's avatar
pk1593
Icon for Helper I rankHelper I
3 years ago

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])...
Tableau to DAX code
pk1593's avatar
pk1593
Icon for Helper I rankHelper I
3 years ago

 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. 

pk1593's avatar
pk1593
Icon for Helper I rankHelper I
3 years ago

v-zhangti - Just wanted to check if you were able to convert the Tableau code to DAX ?