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
I just want to confirm if you resolved this question? If yes, you can accept the answer helpful as the solution or share you method and accept it as solution, thanks for your contribution to improve Power BI.
If you need more help, please let me know.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.