Forum Discussion
What Measure to Identify a New Job?
Hi,
I have this task in my monthly report. I need to identify new jobs in the forecast sheet.
Our forecast sheet looks like this:
| Customer | Project | November 1, 2019 | December 1, 2019 | January 1,2020 | February 1, 2020 | March 1, 2020 | April 1, 2020 |
| Customer 1 | Project 1 | 0 | 0 | 100 | 100 | 100 | 0 |
| Customer 1 | Project 2 | 100 | 100 | 100 | 100 | 0 | 0 |
| Customer 1 | Project 3 | 100 | 100 | 100 | 200 | 200 | 300 |
| Customer 2 | Project 4 | 300 | 400 | 100 | 100 | 100 | 100 |
| Customer 2 | Project 5 | 0 | 100 | 200 | 0 | 0 | 0 |
| Customer 3 | Project 6 | 0 | 0 | 0 | 150 | 0 | 0 |
| Customer 4 | Project 7 | 0 | 0 | 0 | 0 | 0 | 0 |
I need a measure to identify new jobs. In the table above, Customer 1 has a new Project 1, Customer 2 has a new Project 5, and Customer 3 has a new Project 6 because their volume is 0 in the starting month or months. It doesn't matter how many months a customer has 0 volume. As long as it has 0 in the beginning month/months, we treat it as a new job. However, Customer 4's Project 7 is not a new project because it doesn't have any volume in the future months shown up in the table.
I'm also struggling of where to put the measure once we figure it out. I can put customer in the row and project as a drilldown under customer. Then place month in the column. But this measure, no idea...
Does anyone have any idea of how to solve this headache for me? Big thanks to you!
Regards,
Anonymous solution attached with highlighted most recent project
4 Replies
- parry2k
Super User
Anonymous are you looking for this output
Hello parry2k ,
Thank you so much for the instant reply!!
Ideally I want the new projects with an Y/N in a seperate column or something can identify/highlight the project if it's a new one in the same table.
Do you think it's doable?
Regards,
- parry2k
Anonymous solution attached with highlighted most recent project