JIRA tables - issues(bugs/defects) created during sprint time (between start and end dates)

[Anonymous]

Hi, I need if an issue (bug/defect) is created during the sprint cycle. Below are the two data sets which has relation ship via different other JIRA tables.

I would like to create IsCretedInSpritnt? filed based on the dates. At the moment i dont have any date dimension tables. But all date fields are DATE datatype. 

Logic should be Issue Created Date should fall in between Sprint Start and End Dates then YES, else NO.

BOARD_CHARTS_SPRINT_NAME	BOARD_CHARTS_SPRINT_START_DATE	BOARD_CHARTS_SPRINT_END_DATE
Sprint 1	7/20/2022	8/2/2022
Sprint 2	8/3/2022	8/16/2022
Sprint 3	8/17/2022	8/30/2022
Sprint 4	8/31/2022	9/20/2022

ISSUE_KEY	ISSUE_CREATED	BOARD_CHARTS_SPRINT_NAME	IsCreatedInSprint?
21976	6/30/2022	Sprint 1	No
21977	5/15/2022	Sprint 1	No
21978	7/25/2022	Sprint 1	Yes
21979	8/1/2022	Sprint 1	Yes
21980	7/10/2022	Sprint 2	No
21981	8/10/2022	Sprint 2	Yes
21982	8/6/2022	Sprint 2	Yes
21983	7/28/2022	Sprint 2	No

I tried to follow this - https://community.powerbi.com/t5/DAX-Commands-and-Tips/Lookup-value-if-date-is-between-two-dates/m-p... but since I have two different datasets given DAX is not working.

Any leads will be really helpful.

[amitchandak]

@Anonymous , a new column

IsCreatedInSprint =

var _cnt= countx(filter(Table1, Table2[BOARD_CHARTS_SPRINT_NAME] = Table1[BOARD_CHARTS_SPRINT_NAME] && Table2[ISSUE_CREATED] >= Table1[BOARD_CHARTS_SPRINT_START_DATE] && Table2[ISSUE_CREATED] <= Table1[BOARD_CHARTS_SPRINT_END_DATE]) , Table1[BOARD_CHARTS_SPRINT_NAME])

return

if(isblank(_cnt), "No", "Yes")

[Anonymous]

Hi @amitchandak, Its returning differently. Please see below screen shot. Am i missing anything?

Thanks