Data Trim Based on changing date per user

[Anonymous]

Hello

Looking for a few ideas to handle a data trim operation

Two tables for a helpdesk report:

I have incident data exported in an .xls tab that has an incident number (Ticket#) and a user number (ID) (TICKETS DATA)

In a second tab, I have a subset of the users (ID) number and a date (START DATE)  (ProjectDATA)

What I want to do is show only the Ticket# for people that have a matching ID in PROJECT but also fall within a certain date range (15 days before and 15 days after) their START DATE in ProjectDATA.   

So basically we wind up with only incident data that is a 30 day view of tickets before and after a specific start date, but that START DATE could be different for each user.   

(One has startdate of 5/1,  i want tickets from April 16 to  May 15 for that user;   a second starts on mAY 16 so I want ticket# from May 1 to May 30 for them, etc etc...)

 What do ya have for me?

[v-chuncz-msft · Accepted solution]

@Anonymous,

You may take a look at the post below.

https://community.powerbi.com/t5/Desktop/conditional-join/m-p/340423#M152404

[parry2k]

@Anonymousif you can share sample data in excel sheet, will get you the solution.

[Anonymous]

Simple data

So for two users in Project Data i would only want to see those entries in Tickets that are within 15 days of the Email1 date in Project Data for each user.  There would be 2 for bkantesa and 3 for malko left based on the data below.

Project Data

ID	User Name	Email1 Date	Email2 Date	Email3 Date	State
bkantesa	Kento, Barto	11-May-18	-	-	NJ
malko	Mitch, Sam	1-Jun-18	-	-	NJ

Tickets

KB	Submit Date	Product Name	Status	ID
	4/10/2018 0:00	Microsoft Active Directory	Canceled	bkantesa
KBA00036483	1/1/2018 0:40	iPad	Closed	ahujaak
KBA00089817	6/1/2018 0:00	Office 365	Closed	malko
KBA00009875	5/20/2018 0:00	Microsoft Active Directory	Closed	malko
	6/4/2018 0:00	Android Phone	Closed	malko
	1/1/2018 1:05	Office 365	Closed	jonnalla
	5/1/2018 0:00	PartnerNet	Closed	bkantesa
	1/1/2018 1:43	myLEARNING	Closed	harryn
KBA00039304	1/1/2018 2:08	PNet	Closed	rangasmu
	5/20/2018 0:00	Office 365	Closed	bkantesa
KBA00092538	3/1/2018 0:00	Chrome	Closed	malko