Forum Discussion
Excluding weekends from performance metrics is
I know several posts have been made about this, and I have tried the strategies present in those threads. However, I'm still having issues. I think my problem is that I have the datekey of my dimension table constructed from the 'created' date, related to the datetable. The created date is part of my performance calculation and therefore the weekend exclusion is not necessarily checking each day from created to closed, but only if the created date is a weekend or not. How do I fix this? I created a sample file and attached it here, in case my summary is not clear enought. Thanks so much
5 Replies
May be try something like below for calculated column?
= IF ( ISBLANK ( [Closed Date] ), COUNTROWS ( FILTER ( DimDate, [Date] >= 'sample data'[Created] && [Date] < TODAY () && DimDate[DayOfWeekNumber] <> 7 && DimDate[DayOfWeekNumber] <> 1 ) ), COUNTROWS ( FILTER ( DimDate, [Date] >= 'sample data'[Created] && [Date] < 'sample data'[Closed Date] && DimDate[DayOfWeekNumber] <> 7 && DimDate[DayOfWeekNumber] <> 1 ) ) ) + 0ChihiroThis is great, and much closer than I have gotten. However, the ouput is a whole number- as in it's not calculating from the date time values of the created and closed. Any ideas on how to get it to be more granular?
Hmm, I suppose you can use MOD(Now() - [Created], 1) and MOD([Closed Date] - [Created], 1), and add it back to respective calculation result (i.e True part & False part).
try this function with some modification it will help you Clean Master Facebook Lite Mathway
Never seen such an interesting article ever; thank you very much for the great stuff dear one.
