First of all, thank you for your attention and the effort and time you dedicate to the layman.
I have a table called "Estarti" (this is an article statistic), it has the following fields: IdArticu, EndOfMonth, Units, Movement.
MonthEnd is a DD/MM/YYYY date field, IdArticu is text and the others are numeric integers.
These are the units sold per month of each of the different items we work with. "Movement" has a value of 0 if for a month there have been no units sold or 0 and a 1 if the month has had "units" sold other than 0.
I would like to be able to get a list of the items that have had movement in each and every one of the last 12 months, excluding the current month (the table is already filtered and only has those months). That is, the sum of the "movement" column has to be 12 for each "IdArticu". If it doesn't add up to 12, it's because it hasn't had units sold for a month.
Once I have obtained that list I would like to be able to filter it into, for example, those IdArticu whose units sold in each and every one of the last 12 full months has been at least 100 units, then it has been at least 50 units (excluding the previous 100), then at least 30 units, excluding the previous 50 and 100.
I've managed to do it in power query, but it's very laborious for me. Could you help me?
