Forum Discussion
Exponential Constants for the Curve using DAX
Hi PBI Experts, May I know how to calculate Exponential equation constants for the Curves using DAX in Power BI? Need to convert const1=INDEX(LOGEST({Y-RANGE},{X-RANGE}),1) const2=INDEX(LO...
Hi dhineshlee_2528 ,
Can you show the expected result in the form of a picture, we can better help you
If convenient, Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Sharing with you a sample dataset with the required columns( X and Y) used for calculating the exponential curve constants using DAX.
const1=INDEX(LOGEST({Y-RANGE},{X-RANGE}),1)
const2=INDEX(LOGEST({Y-RANGE},{X-RANGE}),2)
| Sum of Drilled interval (m) (x) | Sum of Dry hole days (y) |
| 1936 | 32.81 |
| 1651 | 19.81 |
| 1904 | 22 |
| 2882 | 58.48 |
| 1195 | 9.84 |
| 1383 | 10.12 |
| 1782 | 12.23 |
| 1630 | 21.71 |
| 1483 | 118.92 |
| 1904 | 33.89 |
| 1175 | 18.65 |
| 1329 | 29.69 |
| 1844 | 37.2 |
| 1845 | 18.01 |
| 1340 | 32.96 |