Forum Discussion
Static Date Comparison
Anonymous , I added two more measures. Hope they will help. File is attached
Anonymous , Is it different from the one you asked: https://community.powerbi.com/t5/Desktop/How-Long-Between-Dates/m-p/1022826#M482762
I posted a solution pbix That should work for this one too.
hi amitchandak , I dont believe these are the same questions...
Although the original question you answered does allow me to calculate how many repairs there were in a given day, it does not show me how many are "Open" on any given day
I want to try to create a formula or column that shows the amount of Work Requests that are open on any given day, instead of how long it is between dates
Thank you!
SarahAnonymous , I added two more measures. Hope they will help. File is attached
amitchandak , I think this works!
(I just have to figure out how to subtract from the date before...so 2849+7 for 1/1/2014, 2856+13 for 1/2/2014, 2869+(-5) for 1/3/2014, etc... I know that I could possibly do this if i added an INDEX column, but since my access to the data source is messed up, I will need to find a work around.. )
Anyways, thank you so much!
But for now hopefully this answers my question 😁😁