Date earlier than today

[Dclunie]

Hi all.

Apologies in advance novice user who just started using power bi desktop.

I need a way to report in a custom column called “ Date Status” with a text file based on criteria.

We have ten date columns that are all linked to 10 tasks, and these have a due date within them.

I need to query all columns at the same time and if any dates are in the past, the text in the row to read “Late” else “ On target”

Can anyone show me an example of this working.

Thanks

D

[ryan_mayu · Accepted solution]

@Dclunie 

maybe you can try this

= Table.AddColumn(#"Changed Type", "Custom", each if List.MatchesAll(List.Skip(Record.ToList(_)),each   _> #date( Date.Year(DateTimeZone.LocalNow()),Date.Month(DateTimeZone.LocalNow()),Date.Day(DateTimeZone.LocalNow()))) then "Late" else "on target")

pls see the attachment below