I would like to return Failed Date if, Please see sample data and my Dax formula and error message
Go to Solution.
You need to format your date as text as.
IF( 1=1, FORMAT( [Date], "DD/MM/YYYY" ), "No" )
View solution in original post
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.
IF (AND( TableName[Status] = "Att", TableName[Result] = "Failed"), TableName[Date], "No" )
I hope this help,
Happy to help!
Check out a full recap of the month!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.