Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
Hi
I am new to Dax. I want find difference between two dates in hours. I tried by using DATEDIFF function but it is excluding minutes
I want result like this
Is there another way to solve this probem.
@amitchandak
Solved! Go to Solution.
Hi,
You need to calc the Hour and Minutes separately, then add the particular text Hr and Min to the text one.
use the below code for your measure :
Hi,
You need to calc the Hour and Minutes separately, then add the particular text Hr and Min to the text one.
use the below code for your measure :
Hi
did you use the Interval in your dax :
Appreciate your Kudos and please mark my response as a solution if it helps you
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
101 | |
65 | |
44 | |
37 | |
36 |