CALCULATE Days Left in the current month

[a_mixed_life]

Was wondering if anyone have the DAX calculations to count how many days left in a current month?

[KHorseman]

Days Left in Month = INT(EOMONTH(TODAY(), 0) - TODAY())

[a_mixed_life]

Thanks! Now let me expand on this, how would I calculate "Working" days?

[KHorseman · Accepted solution]

Workdays Left in Month = COUNTROWS(
	FILTER(
		CALENDAR(
			TODAY(),
			EOMONTH(TODAY(), 0)
		),
		WEEKDAY([Date], 2) < 6
	)
)

...assuming that by "working" days you mean Monday through Friday.

The formula I gave previously does not count today as one of the days left in the month. This one does. If you don't want it to count today, you just have to move the start date to tomorrow:

Workdays Left in Month = COUNTROWS(
	FILTER(
		CALENDAR(
			TODAY() + 1,
			EOMONTH(TODAY(), 0)
		),
		WEEKDAY([Date], 2) < 6
	)
)

[dschaurich]

@KHorsemanI'm trying to change it to calculate how many workdays passed on current month, any hint?

[a_mixed_life]

Awesome! Thank you!