Conditional Formatting only working on half a visual

[Pricey79]

Hello, I was hoping someone could help me please.

I have a date column , that is made from this : 

DATES = IF(ISBLANK(Table1[Due Date(Task)]) , Table1[Due Date(Task2)], Table1[Due Date(Task)])

That works fine and gives me the dates I want. However, conditonal formatting is doing something very strange. 

Their are 2 sets of records in Table1 that have been appended together. Record1 and Record2. The formatting is working fine for Record 2, but for Record 1 its showing different colours. 

These are the incorrect ones(Record1)

And this is the format:

Due_Status_action = IF('Table1'[DATES]<TODAY() , "Overdue" ,

IF(('Table1'[DATES] -7)<TODAY() , "Due In One Week Or Less" ,

If(('Table1'[DATES]-14)<TODAY() , "Due in 1-2 Weeks" ,

"Due")))

And this is the colours:

Status_Colours = IF('Table1'[Due_Status_action] = "Overdue" , 1,

IF('Table1'[Due_Status_action] = "Due In One Week Or Less" , 2,

If('Table1'[Due_Status_action] = "Due in 1-2 Weeks" , 3,

0)))

 And then this is the colour:

Green seems to work but nothing else?

Any help would be much appreciated

Thank you

[v-shex-msft]

Hi @Pricey79,

Any update on this? Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[PijushRoy]

Hi @Pricey79 

Can you please check the date column type before combined
Should be Date format only in both the table (not date time)

If solved, mark as solution

[Pricey79]

@PijushRoy  Thank you for taking the time to reply

I've changed the date format and now I get this?

[PijushRoy]

@Pricey79 

Can you please rebuild the table from scratch and measure. I hope error for, same column as per datatype is already used in DAX, better to copy the dax and power query step and rebuild the table.