Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a situation in a marketing report where I have to select people to target for different campaigns every month.
Currently there are situations where the same campaign selections may need to be rerun multiple times during the same month, which has led to duplicate/incorrect counting if I sum by month.
Below is an example of how the data may come to me:
Date | Campaign Label | Campaign Unique ID | Selection | Revenue |
1/1/2019 | TestGroupA | 45646_54654 | 20,000 | $ 100.00 |
1/1/2019 | TestGroupB | 4567328_7351 | 45,000 | $ 2,000.00 |
1/29/2019 | TestGroupA | 45673248_3131 | 15,000 | $ 1,500.00 |
2/1/2019 | TestGroupA | 546832_14 | 19,000 | $ 2,000.00 |
In the above example for TestGroupA I need to capture the 1/29/19 selection for January while ignoring the selection for 1/1/2019, but capturing the revenue. And, I need to also capture the 2/1/19 selection for February as a seperate data point compare to January.
Does anyone have any advice on how I would accomplish that? Thank you.
Hi @Anonymous ,
I still have a little confused about your requirement.
Do you want to get the selection of 1/29/19 and the revenue of 1/1/2019?
If it is convenient, could you share your desired output so that we could help further on it?
Best Regards,
Cherry
User | Count |
---|---|
139 | |
113 | |
103 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |