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 need to calculate the number of working days between two dates. Everything is fine if the start and end dates are in the same month. But if the period is at the turn of the month, the values are incorrect (the number of days is counted to the month with the starting date). Here are simple example of PBI file:
https://www.dropbox.com/s/r7e8twi9720vz6d/List.pbix?dl=0
Thank you for any tips.
Marcin
You have to wrap DATESBETWEEN in KEEPFILTERS. Also, if you're planning on slicing by 'Working Day' in the UI, you have to wrap it in KEEPFILTERS.
Thank you, i was managed to calculate it.
Marcin
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 |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
46 | |
31 | |
30 | |
18 | |
18 |