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 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
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 |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |