out of stock date

[Anonymous]

Hi all,

I have table wich one show wich product in which day wasn't out of stock from warehouse.

My last column shows information about how many day was pass from out of stock date until now, but I want to show how many days that product was out of stocked

thanks.   

[v-frfei-msft]

Hi @Anonymous ,

To creat a calculated column as below. If it doesn't meet your requirement, kindly share your sresult to me.

out of stock = DATEDIFF('Table'[out of stock date],TODAY(),DAY)

[Anonymous]

Hi @v-frfei-msft, 

Yes your colculatioan shows how days was that product out of stock but...

lets say product X is out of stock from warehouse in 2 days, but if in third day it was available in warehouse your calculation would not work becouse it will show 3 (but product X in third day was available) , and I need  to stop calculation in second day.

[CheenuSing]

Hi @Anonymous ,

Your requirement is not clear.

Can you share some data and output required on Google or One Drive and share the link here.

Cheers

CheenuSing

[Anonymous]

dear @CheenuSing , I shared two files, first is all list , and second is only for today 

https://carsondellosa-my.sharepoint.com/:f:/p/vhambardzumyan/Eq0Rf1x4hjFMsS5t1n_y3fgBOnOntIclbQEFRAz...

[CheenuSing]

Hi @Anonymous 

Which file to use for finding a solution ?

Cheers

CheenuSing