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

[Anonymous]

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

[v-chuncz-msft · Accepted solution]

@Anonymous 

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