Forum Discussion

New Member

4 years ago

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...

Need Help

Tips and Tricks

vojtechsima
4 years ago
Hi, fhashim
well, you can first try something like this, instead of DATEDIFF:

([Date A]-[Date B])*24

or 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

fhashim

New Member

4 years ago

Hi vojtechsima,

I can't do it myself so I might have to contact IT support but I just need to be sure that there isn't much that I can do right?

vojtechsima
Super User
4 years ago
Hi, fhashim
well, you can first try something like this, instead of DATEDIFF:

([Date A]-[Date B])*24

or 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

Forum Discussion

Taking Date difference using Power Query or DAX

Related content

Different schema into different destination

clustered column chart with 3 different data points that use 3 different date fields

How to take over connection ownership

Fabric or ADX? Key Differences and Use Case Guidance

MEasure to take difference