Forum Discussion
Get previous iteration from dev ops
Anonymous you need to add a date table in your model, mark it as a date table, set a relationship with your bug/issue table on the date column and then add following measure:
Count = CALCULATE ( COUNTROWS ( BugIssueTable ), DATEADD ( 'Date Table'[Date], -1, DAY ) )
To visualize, use the date column from date table, item type from bug/issue table and the count measure , and this will do it
👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤️
ah yeah that seems simple enough. i appreciate it!
After tinkering around, i dont think this will work for what im looking for. the dates are not days apart, the dates are based off of project length so they could be 01/14/2023, next date could be 3/3/2023 and so on.
in my attached screenshot, i have been trying with no avail to use a date table and index it, joining it to my main table. the date table looks like my screenshot. i thought somehow i might be able to get the bugs for 4/25/2023 to show up on 03/03/2023 with something like 'where index = index -1"