cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vitinho Regular Visitor
Regular Visitor

Calculate function not avaiable

Hi all,

 

I'm trying to use the calculate function on my OCDB and this function isn't avaible for me when I'm trying to create a new collum. Anyone has an ideia of what can be going on?

 

Thanks in advance!

5 REPLIES 5
vitinho Regular Visitor
Regular Visitor

Re: Calculate function not avaiable

Nobody??? I'm getting desperate =/

Phil_Seamark Super Contributor
Super Contributor

Re: Calculate function not avaiable

To me it sounds like you are using Direct Query and I'm pretty sure you can't create calculated columns/measures over Direct Query sources - but I didn't think ODBC was a DQ datasource.  I figured it would import the data and once in you can enhance your model.

 

Are you able to create any calculated measures or columns?


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Moderator v-qiuyu-msft
Moderator

Re: Calculate function not avaiable

Hi @vitinho,

 

It seems you connect to ODBC data source, which calculate function do you want to use to create a calculated column? If you create a calculated column in report view, you can use DAX functions. While in Query Editor, you need to use Power Query functions.

 

It would be better if you can share sample data and expected calculated column values for our analysis.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
vitinho Regular Visitor
Regular Visitor

Re: Calculate function not avaiable

I'm only able to use calculate on measures. It doesn't appear when I'm trying to create a new collumn.

corbusier Regular Visitor
Regular Visitor

Re: Calculate function not avaiable

That sounds like expected behavior. CALCULATE is only for Measures.

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 6 members 2,441 guests
Please welcome our newest community members: