Forum Discussion
Help With Networkdays Excluding Holidays Using Calendar Table
Hi,
Please check the attached file.
NETWORKDAYS expects a separate table for the holidays. You have the holidays included as a column in the calendar table, so you don't need to use NETWORKDAYS.
Your BudgetUnits[Workdays] is a calculated column and will ignore the date slicer. Same with the BudgPerDay.
lbendlin -
Thank you, that got the number working days correct. I'm finding that my calculation for determining the month to date value for the budget units isn't working, specifically with a YearMonth slicer instead of a date slider. When placed into a table, the value is blank. Both BudgetUnits[Workdays] and BudgPerDay functions are now measures instead of calculated columns. I need to display the MTD value of the budget units based on what YearMonth value users select in the YearMonth slicer.
Hi,
Please check the attached file.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
