KPI - Red if 3 month in a row

[Anonymous]

I have data about project progress. 

I am trying to make a KPI for project that allows project to be yellow or red for max 3 month. After that I want a column to counts 1.

Columns I got:

"Projectid": The uniq ID for projects (Hidden of cause)

"Status": 1 if green, 2 if yellow, 3 if red

"Count of Red": 1 if red else 0

"Count of Yellow" 1 if yellow else 0

"Count of Green" 1 if green else 0

"Month" and "Year - month": The same month apear once for each project. The tabel register the given status for each month (Look at the picture):

[Anonymous]

Hello @FreemanZ 

Thanks for your reply

I am not sure I understand.

Do you want me to make a pic. with more data? I cannotn share that, but here I have made some dummy data to kind of give you an idea of what I have.

I hope you can get a sense of the data set up. The data is historical, so it reflects what status a project has been in previously. In my original data set there are many more projects. Thanks!

:

[FreemanZ]

hi @Anonymous ,

please consider post some usable data that well reflects your challenge. 

Post Sample Data

UPDATE: @ImkeF wrote a fantastic article for the best way to post data to the forums: https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-....