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.
Hello,
I am looking to calculate the amount of networkdays between two dates to the exact decimal number. I have tried the following DAX formulas but have come across with problems for each:
NetworkDays = CALCULATE(SUM('Calendar'[Workday]),DATESBETWEEN('Calendar'[Date],JPL[EnteredDate],JPL[ClosedDate]))-1
Problem - Formula calculates only a whole number
Networkdays1 = SUMX(FILTER('Calendar','Calendar'[Workday]=1),(JPL[ClosedDate]-JPL[EnteredDate]))
Problem - Formula calculates as a date.
Usually I am able to switch the format of the column in the "Modelling" tab but power BI will not change formats for these functions. Could anyone provide an appropriate formula or resolution to my decimal networkdays problem?
Thanks in advance!
Have you seen my Net Work Days Quick Measure?
https://community.powerbi.com/t5/Quick-Measures-Gallery/Net-Work-Days/m-p/367362
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 |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |