Forum Discussion
Line chart rolling average status count
Hi, I have departmental project data. This includes the below fields and values: ProjectID: 111, 222, 333 RequestedDate: 10/03/2018, 12/05/2018, 12/05/2018 ResolvedDate: 15/03/201...
Well, you are going to need something like these two Quick Measures which figure out a status at a point in time based upon a date or multiple dates within the data.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365
Thanks for your reply.
The "Open Tickets" url best suits my requirement but I'm not sure how to add a "Status" column to "tmpTable" beside "ID" and "Date" with the logic: IF [Date] = [Effective Date] THEN "Closed" ELSE "Open"
I would then add "Status" to my line charts legend to produce two comparable line charts based on the [ID] count value.
Any help appreciated.