Working days

[Anonymous]

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 · Accepted solution]

[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