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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
manalla
Helper V
Helper V

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

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_NAMEBOARD_CHARTS_SPRINT_START_DATEBOARD_CHARTS_SPRINT_END_DATE
Sprint 17/20/20228/2/2022
Sprint 28/3/20228/16/2022
Sprint 38/17/20228/30/2022
Sprint 48/31/20229/20/2022

 

ISSUE_KEYISSUE_CREATEDBOARD_CHARTS_SPRINT_NAMEIsCreatedInSprint?
219766/30/2022Sprint 1No
219775/15/2022Sprint 1No
219787/25/2022Sprint 1Yes
219798/1/2022Sprint 1Yes
219807/10/2022Sprint 2No
219818/10/2022Sprint 2Yes
219828/6/2022Sprint 2Yes
219837/28/2022Sprint 2No

 

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.

2 REPLIES 2
amitchandak
Super User
Super User

@manalla , 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")

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

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

 

manalla_0-1666888826829.png

Thanks

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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