cancel
Showing results for
Did you mean:
Frequent Visitor

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

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
Super User

@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])

Announcements

#### Power BI March 2023 Update

Find out more about the March 2023 update.

#### Ted's Dev Camp - March 30, 2023

In this session, we'll examine important design issues and decisions that arise when developing with Power BI embedding.

Top Solution Authors
Top Kudoed Authors