cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DomoChris Occasional Visitor
Occasional Visitor

How to select the most recent data within a month?

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:

 

DateCampaign LabelCampaign Unique ID Selection Revenue
1/1/2019TestGroupA45646_54654       20,000 $    100.00
1/1/2019TestGroupB4567328_7351       45,000 $ 2,000.00
1/29/2019TestGroupA45673248_3131       15,000 $ 1,500.00
2/1/2019TestGroupA546832_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. 

1 REPLY 1
Community Support Team
Community Support Team

Re: How to select the most recent data within a month?

Hi @DomoChris ,

 

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

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (2,214)