Combining Different Status into single visual

[GJUDGE]

Hi, 

I have a group of projects which have a series of dates associated with them. The projects are RAG rated based on the variances between certain dates. 

There are 3 main indicators:

Indicator 1 -

• Green if date A < date B
• Amber if date A < date C
• Red if date A < date D

Indicator 2:

• Green if date E < date F
• Red if date E > date F

Indicator 3: 

• Green if date H < date I
• Red if date H > date I

I want to be able to produce a table in power BI as follows:

Project Name	Indicator 1	Indicator 2	Indicator 3
Project 1	Red, Amber or Green	Red or Green	Red or Green
Project 2....

I think the first indicator is confusing me most as it is not simply dependent on two dates. Do I need to calculate three different date variances and then implement a rule to decide which one should be returned?

Any help would be appreciated!

[v-chenwuz-msft]

Hi @GJUDGE,

Can you give some sample data and the expected table.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.