How to create a Measure or Calculated column for End Of Month + 5 Workdays?

[tmyasoutov]

Hi everyone,

I have a date table, but don't know how to create a Ultimo + 5 Workdays calculation. Cannot add the whole table due to the quantity of columns, but some of the information is present, like Workday names. How to create a Measure or Calculated column for End Of Month + 5 Workdays?

Fiscal Year No	Fiscal Year Label	Fiscal Period No	Fiscal Period Label	Fiscal YearPeriod Label	Fiscal YearPeriod Label Sort No	Fiscal Quarter No	Fiscal YearQuarter Label	Fiscal YearQuarter Label Sort No	Year Week Day ISO8601	Year No ISO8601	Year Week ISO8601
2000	FY00	4	P04	FY00 P04	36526	2	FY00 Q2	36526	1999-W52-6	1999	1999-W52
2000	FY00	4	P04	FY00 P04	36526	2	FY00 Q2	36526	1999-W52-7	1999	1999-W52
2000	FY00	4	P04	FY00 P04	36526	2	FY00 Q2	36526	2000-W01-1	2000	2000-W01
2000	FY00	4	P04	FY00 P04	36526	2	FY00 Q2	36526	2000-W01-2	2000	2000-W01
2000	FY00	4	P04	FY00 P04	36526	2	FY00 Q2	36526	2000-W01-3	2000	2000-W01
2000	FY00	4	P04	FY00 P04	36526	2	FY00 Q2	36526	2000-W01-4	2000	2000-W01
2000	FY00	4	P04	FY00 P04	36526	2	FY00 Q2	36526	2000-W01-5	2000	2000-W01
2000	FY00	4	P04	FY00 P04	36526	2	FY00 Q2	36526	2000-W01-6	2000	2000-W01
2000	FY00	4	P04	FY00 P04	36526	2	FY00 Q2	36526	2000-W01-7	2000	2000-W01

[amitchandak]

@tmyasoutov , If you need just sum/count of value based on today

calculate(Sum(Table[Value]), filter(Table, Table[Date]>= eomonth(Today(),0)  && Table[Date]<= eomonth(Today(),0) +5 ) ) )

Or  you can use selected date in place of today , prefer date table  

maxx(allselected(date), Date[Date])