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.
I have a data table with data with current and prior days sales. I am looking for a formula idea that I can use to flag (or specically count the number of unique items) that were in the prior reporting period and are not in the current period. There is not data records for every day so I assigned a number to the reporting periods in reverse order from the most current (MAX) date. Basically I need to see what items are not in the MAX date (1) but were in the prior date (2).
Here's a full analysis of your problem and much more:
https://www.daxpatterns.com/new-and-returning-customers/
For customers just substitute products.
Best
Darek
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 |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |