Compare Dates and Show font in red based on result

[Tanu]

Hi,

I wanted to compare two dates and show font in red when the result is true.
Here’s what I am trying to achieve.
Can some help me understand where i am going wrong

[Measures].[Issue Date IRL 2 Entry]
CASE WHEN DateCompare(
[Measures].[Actual IRL1 Exit Date] > [Measures].[Target IRL1 Exit Date])
THEN
“<span style='color:red>”
END

[zane.baranovska]

Hi @Tanu,

You are on the right track. There are a few adjustments to make this work.

1. Use function DateCompare() to compare two dates. There are more details and example of this function: DateCompare

2. Date that you would like to show in the red color should be between <span ...> and </span>.

3. Make sure to set measure formatting to Markdown (Calculated measures and members)

The updated formula might look like this:

CASE WHEN --compare two dates
  DateCompare(
    [Measures].[Actual IRL1 Exit Date],
    [Measures].[Target IRL1 Exit Date]
  ) > 0
THEN --if Actual date > Target date
  "<span style='color:red'>" || 
  Format([Measures].[Issue Date IRL 2 Entry],'dd mmm yyyy')
  || "</span>" 
END

Check out tips and tricks on measure formatting for more examples:

Measure formatting (markdown and custom)

In this article, I will show a few tips and tricks on how it is possible to format the measures. In eazyBI, there are two interesting ways on how to format measures to get a different appearance. First is our newest formatting option, Text->Markdown (available on Cloud and starting from the eazyBI version 6.1), and second is a Custom format with which you can change the formatting of the measure. [eazyBI_Markdown] Markdown You can use Markdown formatting to show a rich text (bold, italic) or…

Best,
Zane support@eazyBI.com