Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Working days

Hello everybody,   I have managed to calculate the working days but it is in the wrong way. I wanted them to be in an ascending order.   Could you please help me? Thanks 
  • Anonymous's avatar
    Anonymous
    5 years ago

     

    [Working Days Past] = // calculated column
// MonthID must uniquely identify a month
// in the table across all years. It can be
// a number of the form YYYYMM or an integer
// that goes from 1 to the number of months
// in the table.
var CurrentMonth = T[MonthID]
var CurrentDay = T[Date]
var Result =
	COUNTROWS(
		filter(
			T,
			T[MonthID] = CurrentMonth
			&&
			T[Date] <= CurrentDay
			&&
			// This field is a boolean, so
			// there's no need to equate it
			// to anything.
			T[IsWorkingDay]
		)
	)
return
	Result + 0

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

 

[Working Days Past] = // calculated column
// MonthID must uniquely identify a month
// in the table across all years. It can be
// a number of the form YYYYMM or an integer
// that goes from 1 to the number of months
// in the table.
var CurrentMonth = T[MonthID]
var CurrentDay = T[Date]
var Result =
	COUNTROWS(
		filter(
			T,
			T[MonthID] = CurrentMonth
			&&
			T[Date] <= CurrentDay
			&&
			// This field is a boolean, so
			// there's no need to equate it
			// to anything.
			T[IsWorkingDay]
		)
	)
return
	Result + 0