You are on the right track. There are a few adjustments to make this work.
DateCompare() to compare two dates. There are more details and example of this function: https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/mdx-function-reference/datecompare
Date that you would like to show in the red color should be between
<span ...> and
Make sure to set measure
formatting to Markdown ( https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members#Calculatedmeasuresandmembers-Formatting)
The updated formula might look like this:
CASE WHEN --compare two dates
[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')
Check out tips and tricks on measure formatting for more examples:
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, 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.
[Calcaulted measure formatting]
You can use Markdown formatting to show a rich text (bold, it…