Tob_PHelper V2 years agoSolvedStatement formattingHi there, Can someone advise how I can rectify this statement please? If the agreement end date is in this year, then I want the custom column to display 'Active', otherwise 'Inactive'. Anonymous2 years ago(pay attention to case sensitivity) = if Date.IsInCurrentYear([Agreement End Date]) then "Active" else "Inactive --Nate
Anonymous2 years ago(pay attention to case sensitivity) = if Date.IsInCurrentYear([Agreement End Date]) then "Active" else "Inactive --Nate
Anonymous2 years ago(pay attention to case sensitivity) = if Date.IsInCurrentYear([Agreement End Date]) then "Active" else "Inactive --Nate
2 RepliesReplies sorted by Most LikedAnonymousNot applicable2 years ago(pay attention to case sensitivity) = if Date.IsInCurrentYear([Agreement End Date]) then "Active" else "Inactive --NateTob_PHelper V to Anonymous2 years agoThank you very much Anonymous
AnonymousNot applicable2 years ago(pay attention to case sensitivity) = if Date.IsInCurrentYear([Agreement End Date]) then "Active" else "Inactive --Nate
Related contentOR Statement ?DAX FORMAT function Alternative - Switch StatementSupport for MERGE statementSQL Statement opcion errorCOLOR FORMATTING - SWITCH STATEMENT
