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(LOGEST({Y-RANGE},{X-RANGE}),2) to DAX Formula.
3 Replies
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 ,
PFA for the required output.
Thanks,
Athira
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
