Forum Discussion
Counting Previous data
Hey Guys,
Here is link to sample data: https://drive.google.com/open?id=1jWUIMOH3DnQB2pbqUAhXOUQ_re4AeKYH
I have this linked to a Calendar lookup table. I am trying to show on per week and/or per month of how many projects started and completed, BUT i also need to know how many are still active and havent been completed yet that started in the past. So i believe like a cumalitive count.
I need to somehow count ones that have a completion date earlier than the Week in the calendar table. I tryed a few measures using EARLIER function, but couldnt get it working. Here is the graph i have now.
Any help would be appreciated.
Thanks
You may take a look at the post below.
https://community.powerbi.com/t5/Desktop/calculate-open-tickets-by-date/m-p/207644#M91517
1 Reply
- v-chuncz-msftCommunity Support
You may take a look at the post below.
https://community.powerbi.com/t5/Desktop/calculate-open-tickets-by-date/m-p/207644#M91517