topic Re: Calculate number of distinct items removed from list and what items they are in DAX Commands and Tips

Calculate number of distinct items removed from list and what items they are

Jameswhittle91 — Tue, 25 Jul 2023 16:02:08 GMT

Hi, I'd like to calculate the number of items that remove from a list each week. essentially each shopping list has been appended into one master table. I'd like to find the number of items that are no longer on the list (I have a shopping list number column) and what these items were. How would i go about achieving this?

Many thanks in advance for any help

Re: Calculate number of distinct items removed from list and what items they are

mlsx4 — Mon, 21 Aug 2023 13:26:51 GMT

Hi Jameswhittle91

Can you provide an example with some "dummy" data and your expected output? At least, how is your data structured. If you cannot do it, please check this video: https://www.youtube.com/watch?v=u2ImJFc1B7c

The same logic that applies for lost customers will apply for your data

Re: Calculate number of distinct items removed from list and what items they are

mbamber — Mon, 21 Aug 2023 12:58:40 GMT

You can create a list of values for the current week and the same list for the previous one. And then INTERSECT will help you.