Forum Discussion

Nie's avatar
Nie
Helper I
3 years ago
Solved

Get p value from Independent Sample T-Test

Like this thread: https://community.powerbi.com/t5/Desktop/How-to-replicate-T-TEST-excel-function-in-powerBI/m-p/2866324 I am also trying to replicate Excel's t.test using DAX.   One of the info in...
Need Help
  • Nie's avatar
    Nie
    3 years ago

    I've done some testing using Scipy in Python to check the results. T.DIST.2T does appear to give the p value if you can provide the t statistic. Why there is a T.DIST.2T but not a T.TEST in DAX is puzzling. It strongly implies the T.DIST.2T in DAX does something very different. I'll mark this as the "Solution" until I figure how what exactly T.DIST.2T does, why T.TEST is missing, and why I am forced to manually calculate the t-statistic.

Nie's avatar
Nie
Helper I
3 years ago

I've done some testing using Scipy in Python to check the results. T.DIST.2T does appear to give the p value if you can provide the t statistic. Why there is a T.DIST.2T but not a T.TEST in DAX is puzzling. It strongly implies the T.DIST.2T in DAX does something very different. I'll mark this as the "Solution" until I figure how what exactly T.DIST.2T does, why T.TEST is missing, and why I am forced to manually calculate the t-statistic.