Forum Discussion
Get previous iteration from dev ops
So i am building a stacked chart the will result in showing bugs from a previous iteration and issues from a current iteration on the same chart. I have calculated everything i believe i need to sho...
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!