Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
How to find hours between two dates and percentage ?
Above example, how to write dax expression to hours and percentage.
Thanks
kunuthuri
Solved! Go to Solution.
Hi @Anonymous
Use DATEDIFF()
- Quentin
Can you explain the DAX expression?
@Anonymous
You add DATEDIFF(StartDate;EndDate;Hours)
- Quentin
Above date diff no hours, minutes, second etc.....
@Anonymous
Column = DATEDIFF('Monthly Activity'[dStartDate],'Monthly Activity'[dEndDate],HOURS)
Should work
- Quentin
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
97 | |
82 | |
75 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |