DateDiff with Direct Query as Measure

Question

I need to have the Date Difference between two Date columns

# of Minutes = Datediff(OP_ORDER_ITEM_ARCHIVE[PICKING_AT];OP_ORDER_ITEM_ARCHIVE[REFILLING_AT];MINUTE)

I'm using the DateDiff Function but it gives me the following error message:

Query(1,1) Function 'DATEDIFF' is not allowed as part of calculated column DAX expressions on Direct Query models

Can I use it as measure, I know i need to filter the Results somehow by row.

Any help is appreciated

luke611 · Answer

I have exactly the same. DirectQuery + Oracle database. Any ideas?

lbendlin · Answer

DATEDIFF is overrated. Try just subtracting one date from the other. Internally dates are treated as numbers with the whole part representing the days and the fraction representing, well fractions of days. Say you want to know the difference between Date A and Date B in hours, you would write ([Date A]-[Date B])*24

luke611 · Answer

lbendlin&nbsp;many thanks for swift reply. Unfortunately there is another error raised when I change DATEDIFF into simple minus between two dates:&nbsp;ORA-00904: "t0"."DATE_COLUMN": invalid identifier. The exception was raised by the IDbCommand interface.

anonymous · Answer

HI&nbsp;MarionKeller&nbsp;,&nbsp;You can have a look at this blog&nbsp;https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-2-Date-Difference-Across/ba-p/934397&nbsp;https://community.powerbi.com/t5/Desktop/DATEDIFF-in-Direct-Query-Mode-32-bit/m-p/492878&nbsp;Regards,Harsh NathaniDid I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

lbendlin · Answer

As you can see this is an error on the Oracle side. Verify that you got the field name right.

Forum Discussion

DateDiff with Direct Query as Measure

6 Replies

Related content

DATEDIFF DAX

DATEDIFF DAX measure

DATEDIFF as DAX Measure

Power BI Direct Query DateDiff

Dax Measure using DATEDIFF