Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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)
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.
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
dear @CheenuSing , I shared two files, first is all list , and second is only for today
Hi @Anonymous
Which file to use for finding a solution ?
Cheers
CheenuSing
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |