Need Help in DAX

Hi Anonymous 

you can do this by using the conditional formatting option in e.g. a table visual. The formatting rules you described does not cover all possibilities, I think, but this will help you on the way.

First create a measure like this

FormattingMeasure =
AVERAGEX (
    'Table';
    IF (
        'Table'[Status] = "Completed";
        0;
        DATEDIFF ( TODAY (); 'Table'[Target Date]; DAY )
    )
)

Now on the [Progress]-field in the values area of your table, right click and select 'conditional formatting':

Select which option is more appropriate for your case(background or font color). After that, choose Format by rules, and add the rules, making use of the measure above:

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.