Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
I have a table like this:
Date | Customer | Amount |
15-Mar | C | 200 |
1-Apr | A | 100 |
26-May | B | 200 |
18-Jun | C | 300 |
13-Jun | A | 100 |
My problemn is, for each Customer, i need to know which month he bought item and also 2 or 3 months ago, he didn't buy it. If there are 2 or months satisfying same this condition, take the month closest to today.
Sorry for my bad english. I tried but its very complex. Thanks for any help.
Hi @duongan1602
Currently there is no year in your sample data. To compare dates with today, you need to have Year/Month/Day for date values.
In addition, how to understand the condition "also 2 or 3 months ago, he didn't buy it"? In the current sample data, customer A and C bought the item twice. Which month should be returned for them? You can provide some examples with dummy data to explain the output result. This can help us understand it better.
Best Regards,
Community Support Team _ Jing
Hi,
Share some more data and show the expected result.
@duongan1602 I created a sample file with your data and a possible way to solve this: Filter date_month satisfy complex condition 2022-07-10.pbix
User | Count |
---|---|
99 | |
86 | |
78 | |
75 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |