Forum Discussion
Simple Question - creating future date with color coding - do we need a date table?
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 )
You are missing the VAR declaration in front of __value, sorry I just realized I made an error in my previous response.
Nxt QSA =
VAR __value = MAX ('Document Status Tracker'[Last_Qual_Settings_Assess__c] )
RETURN
IF ( ISBLANK ( __value ), BLANK(), __value +365 )
zaza - good catch - we need a VAR to get the RETURN to work 😊
But, now the ID's with blank QSA's are no longer displaying in the table...
When I remove the Next column, the records (rows) with blank QSA field are again displayed
So a good solution for not showing ID's with blank fields but since I'm adding about 20 documents (with due dates) to this table
As context, this report is tracking annual documents related to a homeless program - so much paperwork to manage!
Let me know if you have any other coaching - and I can certainly open this as a new Community Question
To also show the empty values, replace BLANK() with with double quotes ""
measure = VAR __value = MAX ( 'Table'[Column] ) RETURN IF ( ISBLANK ( __value ), "", __value + 365 )