PDA

View Full Version : Student T-distribution in DAX



PierreLC
2017-08-01, 03:27 PM
Hello everyone,

I would like to use the Student t density function & cumulative probability function in a mesure related to a data table in PivotTable Fields.
Excel has it with T.DIST(..., ..., FALSE/TRUE). However is it a more or less straightforward to use an equivalent in DAX?

Thanks in advance for your insights!

PierreLC
2017-08-01, 04:17 PM
I have also posted the same question in Excel Forum:
https://www.excelforum.com/excel-formulas-and-functions/1195143-student-t-distribution-in-dax.html

PierreLC
2017-08-02, 10:39 AM
I update my post because this is not the density function but the inverse of the cumulative one I do need to compute:

I would like to use the Student T cumulative probability function & its inverse in a measure related to a data table in PivotTable Fields.
Excel has a T CDF with T.DIST(..., ..., TRUE) and its inverse with T.INV. However is there any more or less straightforward way to use an equivalent in DAX?

Thanks in advance for your insights!

I have also posted the same question in Excel Forum:
https://www.excelforum.com/excel-formulas-and-functions/1195143-student-t-distribution-in-dax.html