Forum Discussion

FEninja_'s avatar
FEninja_
Helper I
3 years ago
Solved

How to Iterate through Multiple Dates

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.
EXAMPLE:
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] )

 

 

hello.UserStories = 
// 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]
)

Return retval 

 

 

 

2 Replies