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 getti...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    6 years ago

    Anonymous 

     

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

v-chuncz-msft's avatar
v-chuncz-msft
Community Support
6 years ago

Anonymous 

 

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