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 data that gets loaded monthly. Each month is a snapshot of all active customers. My goal is to compare the most recent snapshot to the same period last year so I can categorize customers. Here is a sample of a scaled down dataset.
I was able to calculate a table that categorizes each customer and then used measures to count each category. The issue is that this approach is not dynamic.
The pbix file attached has my attempt to make the table dynamic. My [YoY Cust Categories] is essentially my calculated table in measure form. I don’t think this approach will work. It is very slow and when I use it in my scaled-up data set I get a memory error.
Any other approach will greatly appreciate.
Data: https://drive.google.com/file/d/1ZbipUeq7psvY9m0_wk55Az7BVWOKp9TU/view?usp=sharing
PBIX: https://drive.google.com/file/d/1Xpei1D6KqRALHcFGKKDWNVj_xJFCdE_X/view?usp=sharing
Solved! Go to Solution.
Hi @nbs333
Here's how to perform such an analysis properly: Calculate New, Returning, Lost, and Recovered Customers in #dax - SQLBI
Hi @nbs333
Here's how to perform such an analysis properly: Calculate New, Returning, Lost, and Recovered Customers in #dax - SQLBI
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 | |
16 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |