Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register 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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
88 | |
86 | |
83 | |
68 | |
49 |
User | Count |
---|---|
138 | |
111 | |
104 | |
65 | |
64 |