SYSDATE minus other "DATE"

[DCORTESR]

Hi, I have a connection to an Oracle database through Direct Query, I need to subtract a date type column from sysdate.

This can be directly from the query to Oracle or through Power BI.

I mean:

(SYSDATE) - (FECHA_FIN)

I share my query:

Can anyone guide me?

[dax · Accepted solution]

Hi DCORTESR,

You could try to use query like below 

SELECT TO_DATE('2000-01-02', 'YYYY-MM-DD') -  
       TO_DATE('2000-01-01', 'YYYY-MM-DD') AS DateDiff
FROM   dual

Or 

SELECT DATEDIFF(day,'2016-06-05','2016-08-05') AS DiffDate

in Oracle query

Or you could ry to create column or measure like below in powerbi

DATEDIFF([field1], [field2], day) 

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.