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

     

1 Reply

  • 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