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
