Forum Discussion
Solved
Simple Question - creating future date with color coding - do we need a date table?
This feels like a simple question but I'm having trouble making it work... Our goal is to create a new date column "Next Qualified Setting Assessment" with a date that is one year from the "Last Qua...
Your test doesn't work because a measure needs to be able to return a single value.
try:
nxt QSA = MAX ( 'Document Status Tracker'[Last_Qual_Setting_Assess__c] ) + 1
If you make a calculated column instead of a measure, than the syntax you were trying would work:
nxt QSA = 'Document Status Tracker'[Last_Qual_Setting_Assess__c] + 1
To also show the empty values, replace BLANK() with with double quotes ""
measure = VAR __value = MAX ( 'Table'[Column] ) RETURN IF ( ISBLANK ( __value ), "", __value + 365 )
To also show the empty values, replace BLANK() with with double quotes ""
measure =
VAR __value = MAX ( 'Table'[Column] )
RETURN
IF ( ISBLANK ( __value ), "", __value + 365 )
