Forum Discussion

rbowen's avatar
rbowen
Helper III
1 year ago
Solved

Help With Networkdays Excluding Holidays Using Calendar Table

I need to calculate the number of budget units per day from a table that only gives the budget numbers in terms of the entire month. I've created a calendar table that dynamically calculates when US ...
Need Help
rbowen's avatar
rbowen
Helper III
1 year ago

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.

  • rbowen's avatar
    rbowen
    Helper III
    1 year ago

    Thank you Ashish, that appears to have done the trick. And thank you lbendlin , your answer was part of the solution as well, I had a filter set incorrectly that causing some of the data to go missing. Many thanks to you both. 

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      1 year ago

      You are welcome.