Forum Discussion
Static Date Comparison
Hi,
I am trying to have a static date table, which I have created, and compare this to a Query pull table.
I am trying to see that for example, on March 19, 2020, how many Work Requests are "Open". This meaning that a Work Request has been created on or before March 19, 2020, and has not been completed before March 19, 2020.
| REPAIR_DATE | DATE_OPENED |
| 3/17/2020 | 3/16/2020 |
| 3/19/2020 | 3/13/2020 |
| 3/19/2020 | 3/19/2020 |
| 3/20/2020 | 3/18/2020 |
| 3/27/2020 | 3/18/2020 |
| 4/9/2020 | 3/19/2020 |
So in the table above, the number of "Open" Work Requests would be 1 as of 3/19/2020
I am having trouble creating measures in my Date table to compare to the Query pull table, or to adjust based on a date being used in the dashboard filter
Please let me know if this question does not make any sense
Thank you!
Anonymous , I added two more measures. Hope they will help. File is attached
6 Replies
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
Anonymous ,
So in the table above, the number of "Open" Work Requests would be 1 as of 3/19/2020
I am having trouble creating measures in my Date table to compare to the Query pull table, or to adjust based on a date being used in the dashboard filter
I'm confused on your description. Could you share the sample data of Query pull table and clarify more details about the logic of calculating "Open" Work Requests?
Regards,
Jimmy Tao
Hi v-yuta-msft ,
the Opened Work Request just means the date that the Work Request was recieved in the system. There is no calculation behind it
My question is how to show the number of Work Requests that are incomplete on a certain day.. if that makes sense
Thank you!
Sarah
