Forum Discussion
New Column to Show the First Month with Data Values
I am trying to create a new column that can tell me which month each project starts producing revenue. I need this column to be in the data table (not just through a table visualization) so that I can utilize this new column as a dropdown filter. For example, I would want to select a filter to see all project names that start making revenue in August, then switch over to see the ones that start in September.
Any help would be appreciated. Thank you!
Original Data Set:
| Project | January | February | March | April | May | June | July | August | September | October | November | December |
| Project 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 150 | 175 | 200 | 200 | 200 |
| Project 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 150 | 300 | 300 |
| Project 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 400 | 400 | 400 |
| Project 4 | 0 | 0 | 0 | 0 | 0 | 0 | 200 | 150 | 150 | 100 | 100 | 75 |
Desired Data Set:
| Project | January | February | March | April | May | June | July | August | September | October | November | December | Revenue Start |
| Project 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 150 | 175 | 200 | 200 | 200 | August |
| Project 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 150 | 300 | 300 | September |
| Project 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 400 | 400 | 400 | October |
| Project 4 | 0 | 0 | 0 | 0 | 0 | 0 | 200 | 150 | 150 | 100 | 100 | 75 | July |
1 Reply
- amitchandak
Super User
JenKF , You can show the same in grand total
if(isinscope(Table[Month], [measure],
Minx(Values(Table[Month]), if([Measure] >0, [Month], blank())
) )
