Return Date if condition is True

[moeconsult]

I would like to return Failed Date if, Please see sample data and my Dax formula and error message 

@Greg_Deckler 

[Mariusz]

Hello @moeconsult

You need to format your date as text as.

IF( 1=1, FORMAT( [Date], "DD/MM/YYYY" ), "No" )

Best regards
Mariusz

If this post helps,then please consider accepting it as the solution.

Please feel free to connect with me.
Linkedin

[ibarrau]

Hello. Try adding the table name in your code as the syntax expects. As 'Table'[Column]. You cannot use [columnname]. They are reserved for measurements and not for columns.

So try:

IF (AND( TableName[Status] = "Att", TableName[Result] = "Failed"), TableName[Date], "No" )

I hope this help,