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 All,
Need your help in calculating number of days from 2 dates exluding Saturday and Sunday in query editor.
Thanks and Regards
Abhijit
Solved! Go to Solution.
@Anonymous,
You may refer to the following post.
https://community.powerbi.com/t5/Desktop/How-to-calculate-net-working-days-Step-by-Step/td-p/232478
@Anonymous,
You may refer to the following post.
https://community.powerbi.com/t5/Desktop/How-to-calculate-net-working-days-Step-by-Step/td-p/232478
Add a calculated column to your date table to return 1 for a weekday and 0 for a weekend, then add the new calculated column based on the dates you provide.
Hope that helps!
Thanks, Can you please help me with the logic.
Regards
Abhijit Mishra
Assuming you have a date table, add a calculated column:
IsWeekday = WEEKDAY('Date'[Date],2) <= 5
Then in your measures you can use this as logic, for example:
Sales = CALCULATE(SUM(Sales[SalesAmount]), 'Date'[IsWeekday] = TRUE())
It doesn't exclude a gap.
I also tried this but doesn't work if we require use x-axis only continuous.
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 |
---|---|
113 | |
98 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |