Today's Date + measure (integer)

[Anonymous]

I've created a measure that projects the number of days left to complete a project

Projected number of days till completion = backlog/average worked per day

I'm wanting to return today's date + projected number of days till completion

for example: today's date + 5 and i want it to return in a (1/11/1111) if possible Thank you ! 

[Anonymous]

@Anonymous 

You can create a table with working dates only based on the calendar. Then used that column as the data column.

Table 2 = CALCULATETABLE('Table',FILTER('Table',WEEKDAY([Date],2)<>6 && WEEKDAY([Date],2)<>7))

Paul Zheng

[amitchandak]

@Anonymous 

Try like

Measure = Today +5

Or

measure =

var _1 = maxx(Table,Table[Col])

Return

Measure = Today +_1

[Anonymous]

I'm wanting to take into account working days

What I want: 

Projected date = Today + measure 

so if it was a thursday and the measure output was 2 I would want to display monday's Date , 2 being + 2 working days not calendar days

Sorry if i was vague, i'm wanting to Add the measure (projected number of days till completion) to today's date but in terms of working days to exclude weekends

[Anonymous]

Check solution here
https://community.powerbi.com/t5/Desktop/Add-working-days-to-a-date/td-p/146945