Forum Discussion

vitinho's avatar
vitinho
Icon for Helper I rankHelper I
9 years ago

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 ...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

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