Forum Discussion
Control logistics
Guys, good morning!
I need help to discover the recurrence of a product in my inventory, in my data sheet I have two columns (Date, Product) where 1 product can have several dates being 1 date per line, what I need to know is the percentage of products that are in my stock today since yesterday, ie 100 products I have in stock today, how much % is there since yesterday?
thank you in advance
Vitor_sp_bo , with help from date table
This Day = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Date]=max('Date'[Date])))
Last Day = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Date]=max('Date'[Date])-1))then
Present on both days = Present on both days = countx(Values(Table[Product]), not(isblank([Last Day])) && not(isblank([This Day])) )
Presnet today = countx(Values(Table[Product]), not(isblank([This Day])) )
Then calculate the ratio
Idea from
1 Reply
Vitor_sp_bo , with help from date table
This Day = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Date]=max('Date'[Date])))
Last Day = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Date]=max('Date'[Date])-1))then
Present on both days = Present on both days = countx(Values(Table[Product]), not(isblank([Last Day])) && not(isblank([This Day])) )
Presnet today = countx(Values(Table[Product]), not(isblank([This Day])) )
Then calculate the ratio
Idea from