Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
@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")
Hi @amitchandak, Its returning differently. Please see below screen shot. Am i missing anything?
Thanks
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |