Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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
v-piga-msft
Resident Rockstar
Resident Rockstar

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

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.