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