Networkdays

[AndyMax]

Hi

My formula below works fine but I want but I want to change +1 that is a static value (marked with red) to a dynamic value that can be found in column named leadtime.

=CALCULATE(LASTDATE(dbdata[Dc shipped dag]);FILTER(dbdata;dbdata[CalculatedColumn5]=EARLIER(dbdata[CalculatedColumn5])+1&& dbdata[CalculatedColumn6]=1))

Anyone that have an idea how to do that?

Br Andy

 

[AlanY]

what's the criteria to locate that dynamic value?

 

[AndyMax]

Hi Alan

I'm not sure if I understand you right but the value is already given within the data

CalculatedColumn7=CALCULATE(LASTDATE(dbdata[Dc shipped dag]);FILTER(dbdata;dbdata[CalculatedColumn5]=EARLIER(dbdata[CalculatedColumn5])+1&& dbdata[CalculatedColumn6]=1))

I want to replace +1 with the data in column Leadtime

Dc shipped dag CalculatedColumn6 CalculatedColumn5 CalculatedColumn7 Leadtime 2016-07-19 00:00 1 8 2016-07-20 00:00 2 2016-07-27 00:00 1 14 2016-07-28 00:00 1 2016-07-28 00:00 1 15 2016-07-29 00:00 4 2016-07-28 00:00 1 15 2016-07-29 00:00 1 <tbody> </tbody>

<colgroup><col><col span="3"><col></colgroup><tbody>
</tbody>

Br Andy

 

[AlanY]

sorry, just realised that your question is under Power BI that I known nothing about.
have to pass the baton on.

 

[AndyMax]

thx anyway