Control logistics

[Vitor_sp_bo]

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

[amitchandak · Accepted solution]

@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

https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/b...