Forum Discussion
Anonymous
6 years agoNot applicable
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-msftCommunity Support
Anonymous
You may do the calculation by SQL statement in the Advanced options.