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 )
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
zaza perfect solution! 😀
so, for a Measure, why doesn't dax return a single value? what other values is it seeing?
And, is there a "tweak" to show blanks if the Quality Setting Assessment is blank?
Thanks so much for the quick, helpful reply!
A measure is a calculation, and as any calculation it returns a singular value. If you specify a column in your measure, you need to use an aggregation such as MAX/MIN/SUM. Otherwise what you're saying is add 1 and "Column" together. But what is Column? Column is not a number, so the calculation cannot return a result. But, MAX of Column IS a number, so that is why that works.
to show blank values try:
measure = VAR __value = MAX ( 'Table'[Column] ) RETURN IF ( ISBLANK ( __value ), BLANK(), __value + 365 )
