Count Working Days with Month and Week Starting Slicer Filters
Hi Power BI Community, I am having trouble with a measure that calculates number of working days based on my date calendar. When I use a slicer that has only the month it returns working days as intended, when I use a slicer that has only the start week, it returns days as intended. The problm is when I have a slicer that has Month and Start Week. It seems that when the slicer has both and I select a week, it defaults to the month. See measures and examples below. If anyone can please help, I've tried several different approaches but none allow me to have Month and Week in a single slicer 😞 Date Master Table: AddIsWorkingDay = Table.AddColumn(AddMonthWeekStartNumber, "IsWorkingDay", each if Date.DayOfWeek([Date], Day.Monday) > 4 then "Weekend" else "Weekday") Measure: Number of Working Days =CALCULATE (COUNTROWS('Date Master'),'Date Master'[IsWorkingDay]= "Weekday") Examples:
Working days since beginning of month
Hi all, I want to create a measure that will display the number of working days it took for uploading a certain document. For a KPI dashboard I have a measure that a certain measure is uploaded before the 10th working day that month. My source data looks like this: I have a date table tha talso has the working days included: Ideally I woudl now get a measure that takes the last date for a certain process (e.g. 16 january in top example) and calculates how many working days it's been since the beginning of that month, i.e. the 16th is the 11th working day. I was thinking of something like adding a column "Number workday" or something, that says which working day the date is, but I'm not sure how this would work or if it is the best/most elegant solution. I would love to hear if this is possible and if so how, Thanks anyway for any tips and tricksCount working days of running month [Friday is weekend only] & Days elapsed
Hi Experts, Please help me out! Struggling to create a measure which will return total working days of current month dynamically [please note, Friday is only weekend in my organization]. I would also want to exclude holidays. I have a calendar table [see scrrenshot], now I want to calculate two measures 1. Total working days of current month 2. Days Elapsed = First Date of current month - Today () -1 [Excluding weekends and holidays] Thans in advance Mamun
