Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculated Column is not working in Power BI Direct Query Mode with Oracle

Hi, 

I am trying to Create below Calculated Column in Power BI Direct Query Mode

 

Calc_Duration= DIVIDE(HOUR([DT_Cal_Date])*3600+ MINUTE([DT_Cal_Date)*60 + SECOND([DT_Cal_Date]),60)

 

But getting error in power bi.

 

Can you please help me with this

  • Anonymous 

     

    You may do the calculation by SQL statement in the Advanced options.

1 Reply

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support

    Anonymous 

     

    You may do the calculation by SQL statement in the Advanced options.