cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FEninja_
Frequent Visitor

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] )

FEninja__0-1672966092407.png

FEninja__1-1672966109387.png

 

 

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 

 

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@FEninja_ , The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.


 

But I think HR approach can help

Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

 

View solution in original post

2 REPLIES 2
Gokul_G16
Resolver I
Resolver I

Hey @FEninja_,

if your getting data soureces only excel means

you  can manually enter the excel file name is
01-02-2023 inside the excel bookk just give the cookies number.
01-04-2023  '
01-06-2023  ''
Final thing is just take the excel from get data in power BI folder selection option.
Post that you can combine and merge then you will get  it .

for date wise how many count of cookeis you hvaing.

Thanks .
Gokul

amitchandak
Super User
Super User

@FEninja_ , The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.


 

But I think HR approach can help

Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

 

Helpful resources

Announcements
Exciting changes

Power BI Community Changes

Check out the changes to the Power BI Community announced at Build.

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Kudo Data Story carousel

Data Stories Gallery

Visit our Data Stories Gallery and give kudos to your favorite Data Stories.

Top Solution Authors