IF max date minor that TODAY DAX

[twister8889]

Hi guys,

I don't understand how to create an if, for each line of my table to verify that Table1[Date] is < Today. If Table1[Date] is < Today, DUE, Table1[Date].

I need to show this in the table, so I need to summarize all values in DUE, and show all lines dates for else.

I tried create this dax, but not working

if(max(Table1[Date]) < TODAY(), "DUE", max(Table1[Date]))

How do I do this?

Date	Value
DUE	7869
01/10/2021	90
01/02/2021	100
02/07/2021	45

[amitchandak · Accepted solution]

@twister8889 , Create a new column

if([Date] < today(), "Due", [Date] & "" )

[twister8889]

First of all, thank you so much for your answer...

Its working now, thanks

So in this case, I need to use Column and not Measure!!!!! ok, thank you. Its better create this in power query ?