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
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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?

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

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

  • corbusier's avatar
    corbusier
    Icon for Advocate IV rankAdvocate IV
    9 years ago

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