Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I need to run a report to see how long it takes something to be done.
I have
StartDate and EndDate columns and can use a DateDiff(EndDate,StartDate) to get total days it took.
What I would like to do is be able to NOT count weekend days in the count. So example would be
StartDate EndDate ActualTotalDays TotalDaysWOWeekends
1/31/2018 2/2/2018 2 2
2/2/2018 2/7/2018 5 3 (not counting 2-3 & 2-4)
Solved! Go to Solution.
Does something go in [Value] area? Here is my formula and I get "The arguments in GenerateSeries function cannot be blank
TotalDaysWOWeekends =
VAR MyDates =
ADDCOLUMNS (
GENERATESERIES ( V_ACCT[visit_disch_date] + 1, V_ACCT[V_ACCT_HIM_Grouper.ipg_mrcomp_date] ),
"Day", WEEKDAY ( [Value], 2 )
)
RETURN
COUNTROWS ( FILTER ( mydates, [Day] <= 5 ) )
HI @kattlees
Try this Column
TotalDaysWOWeekends = VAR MyDates = ADDCOLUMNS ( GENERATESERIES ( TableName[StartDate] + 1, TableName[EndDate] ), "Day", WEEKDAY ( [Value], 2 ) ) RETURN COUNTROWS ( FILTER ( mydates, [Day] <= 5 ) )
Does something go in [Value] area? Here is my formula and I get "The arguments in GenerateSeries function cannot be blank
TotalDaysWOWeekends =
VAR MyDates =
ADDCOLUMNS (
GENERATESERIES ( V_ACCT[visit_disch_date] + 1, V_ACCT[V_ACCT_HIM_Grouper.ipg_mrcomp_date] ),
"Day", WEEKDAY ( [Value], 2 )
)
RETURN
COUNTROWS ( FILTER ( mydates, [Day] <= 5 ) )
Thank you so much! This worked perfectly.
Your formula seems correct
You could share your file with me
VALUE is the column created by GenerateSeries function
May be you have some BLANK dates
Yes I get this error when I make any of the dates is BLANK
See the pic below
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |