Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Conditionally formatting a date field

I am having a problem conditoinally formatting a date colum after I have selected do show the "latest" date.  The color column (based on field) is not matching with the correct date.  Any suggestions...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, Anonymous ;

    You could create a measure ,then use contiditional format.

    1.create a measure .

    Measure = 
var _diff=DATEDIFF(MAX('Table'[Order Date]),TODAY(),MONTH)
return SWITCH(TRUE(),_diff<1,"white",_diff<2,"yellow",_diff<3,"orange","red")

    2.use conditional format.

    The final output is shown below:

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, Anonymous ;

You could create a measure ,then use contiditional format.

1.create a measure .

Measure = 
var _diff=DATEDIFF(MAX('Table'[Order Date]),TODAY(),MONTH)
return SWITCH(TRUE(),_diff<1,"white",_diff<2,"yellow",_diff<3,"orange","red")

2.use conditional format.

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.