Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everyone,
I'm facing an issue with Power BI, I would like to calculate the amount of days between 2 dates.
I can't use networkdays because I need a decimal number (I will convert it to Days/hours)
I need to calculate how long a case is open
So in my dim_date, I added the following calculated column:
Networkdays returns whole number, and I woul like to get the time in hour
For example, if it returns 1.25, it means 30h
@Ponyglyph , You can use networkdays, you can also supply a holiday list to this function
Power BI - Business day with and without using DAX Function NETWORKDAYS: https://www.youtube.com/watch?v=Qs03ZZXXE_c
https://medium.com/@amitchandak/power-bi-dax-function-networkdays-5c8e4aca38c
User | Count |
---|---|
92 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |