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
How do I do this?
Go to Solution.
@twister8889 , Create a new column
if([Date] < today(), "Due", [Date] & "" )
View solution in original post
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 ?
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.