Forum Discussion
vitinho
9 years agoHelper I
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 ...
Phil_Seamark
9 years agoMicrosoft Employee
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?