Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
FMPE
Frequent Visitor

Some DAX Functions not working

Hi!

I have an issue where a large number of DAX functions are not working i.e. they're not even recognized by the program.

 

I wanted to try to do some simple linear regression in DAX, but when I try using either the LINEST or LINESTX functions, whether I'm doing so in a table or in a measure, they're not recognized. Not only does intellisense not pop up with anything, but I get the error

"Failed to resolve name 'LINESTX'. It is not a valid table, variable, or function name.

 

Is there some sort of setting I have to enable to use statistical functions or the like? I have had no issues using the aggregation, calender, or filter functions, or any other function for that matter, but these two seems like they're unusable for me.

 

Thanks in advance!

1 ACCEPTED SOLUTION
johnt75
Super User
Super User

LINEST and LINESTX are relatively new functions, you'll need to be on a recent version of Power BI Desktop. You'll need at least Jan / Feb 2023 I think.

View solution in original post

4 REPLIES 4
jdbuchanan71
Super User
Super User

@FMPE 

There is a bug in the current version of PowerBI desktop I think where the intellisense shows the error but the functions still work.  It is mentioned in this video for SQLBI.
https://www.sqlbi.com/articles/implementing-linear-regression-in-power-bi/

 

Ah, that's good to know. However, I think my issue might be slightly different, as I haven't been able to get the functions to work at all.

johnt75
Super User
Super User

LINEST and LINESTX are relatively new functions, you'll need to be on a recent version of Power BI Desktop. You'll need at least Jan / Feb 2023 I think.

FMPE
Frequent Visitor

Ah, that's the issue! I assumed I had the newest version, but apparently my work hasn't yet cleared / set up that version for download. I should've just checked the version first, but think to check whether those were functions and/or whether I had an old verison.

 

Thank you!

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.