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.
I have a table which contain the following columns
I woulld like to calculate the number of the working days between those days.
I have created a table where I have defined my calendar according to local Holidays.
The last column contain a logical value that define how to consider that date.
But to be honest I am not able to find a simple way to do it.
Is there a simple solution for a beginner?
Thanks in advance for your help.
Solved! Go to Solution.
@gpiero Try this... Let me know if it works.
Column = CALCULATE ( COUNTROWS ( 'Calendar Table' ), ALL ( 'Calendar Table' ), DATESBETWEEN ( 'Calendar Table'[Date], Table[Start Date], Table[End Date] ), 'Calendar Table'[IsWorkingDay] = "Y" )
Many thanks. Your solution work perfectly and I have more opportunity to apply it again.
gpiero
@gpiero Try this... Let me know if it works.
Column = CALCULATE ( COUNTROWS ( 'Calendar Table' ), ALL ( 'Calendar Table' ), DATESBETWEEN ( 'Calendar Table'[Date], Table[Start Date], Table[End Date] ), 'Calendar Table'[IsWorkingDay] = "Y" )
Many thanks. Your solution work perfectly and I have more opportunity to apply it again.
gpiero
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |