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, 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
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.
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
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 |
---|---|
51 | |
27 | |
24 | |
13 | |
8 |
User | Count |
---|---|
74 | |
52 | |
47 | |
16 | |
12 |