Forum Discussion
Solved
Taking Date difference using Power Query or DAX
I am working on building a dashboard which takes data from a view using backend as snowflake. I can't make much changes to backend due to limited access. I am facing issue while computing date di...
Hi, fhashim
well, you can first try something like this, instead of DATEDIFF:([Date A]-[Date B])*24or you can check the following blog posts:
https://community.powerbi.com/t5/Desktop/DATEDIFF-in-Direct-Query-Mode-32-bit/m-p/492878
https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-2-Date-Difference-Across/ba-p/934397
Hi, fhashim
Is your source a SQL Database? If so, is the query (SQL) specific enough?
If you write a SQL query, write it as detailed as possible (take specific columns, tables etc).
If you write something like this: Select * from * , it's not really optimized and you can face those issues.
If you can't write it yourself, please refer to your IT department.