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 ?
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!