cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

out of stock date

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

tempsnip.png

thanks.   

5 REPLIES 5
Highlighted
Super User I
Super User I

Re: out of stock date

Hi @Vrto95 ,

 

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

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!
Highlighted
Helper I
Helper I

Re: out of stock date

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

Highlighted
Community Support
Community Support

Re: out of stock date

Hi @Vrto95 ,

 

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)

Capture.PNG

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Highlighted
Helper I
Helper I

Re: out of stock date

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.

Highlighted
Super User I
Super User I

Re: out of stock date

Hi @Vrto95 

 

Which file to use for finding a solution ?

 

 

Cheers

 

CheenuSing

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors