New Column to Show the First Month with Data Values

[JenKF]

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

[amitchandak]

@JenKF , You can show the same in grand total

if(isinscope(Table[Month], [measure],

Minx(Values(Table[Month]), if([Measure] >0, [Month], blank())

) )