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
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
90 | |
84 | |
76 | |
64 |
User | Count |
---|---|
135 | |
112 | |
98 | |
98 | |
92 |