Hello, I am trying to iterate through multiple dates.
For example: Lets take the analogy of someone giving me a cookie.
For every day that someon gives me a cookie, I'd like to be able to track how many cookies I was given on each day.
12.27.22 - 1 Cookie Given
12.28.22 - 4 Cookies Given
12.29.22 - 2 Cookies EATEN
12.30.22 - 6 Cookies given
(Total Cookies =9)
My question is - How can I tell Power BI to do this?
( My real situation below, where "Cookies" is replaced with User Stories [scrum speak] )
// Calculate user stories from date'date' to the beginning of sprint. (Date >= sprint start && date <= date'date')
// Stories - New, Closed, Removed
VAR retval = CALCULATE(
[Total User Stories]