Forum Discussion
NewbieJono
Post Partisan
Post PartisanReturn 0 if blank
hello all, prob an easy one for someone, how can i get this code to return 0 if blank
NEW RAG =
VAR __workStream = 'FACT - Backlog'[Grouping]
VAR __daysOld = 'FACT - Backlog'[Days Old]
RETURN...
Hi NewbieJono ,
Please modify the formula like this:
NEW RAG = VAR __workStream = 'FACT - Backlog'[Grouping] VAR __daysOld = 'FACT - Backlog'[Days Old] RETURN CALCULATE ( MAX ( 'RAG MATRIX (TESTING)'[RAG] ), 'RAG MATRIX (TESTING)'[Workstream] = __workStream, __daysOld >= 'RAG MATRIX (TESTING)'[Min Range], __daysOld <= 'RAG MATRIX (TESTING)'[Max Range] ) + 0Or like this:
NEW RAG = VAR __workStream = 'FACT - Backlog'[Grouping] VAR __daysOld = 'FACT - Backlog'[Days Old] VAR __result = CALCULATE ( MAX ( 'RAG MATRIX (TESTING)'[RAG] ), 'RAG MATRIX (TESTING)'[Workstream] = __workStream, __daysOld >= 'RAG MATRIX (TESTING)'[Min Range], __daysOld <= 'RAG MATRIX (TESTING)'[Max Range] ) RETURN IF ( __result = BLANK (), 0, __result )Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
NewbieJonoPost Partisan
Post Partisansorry at which point do i put the 0 ?
which is the preferred method ?
v-yanjiang-msft
Community Support
Community SupportHi NewbieJono ,
Please modify the formula like this:
NEW RAG =
VAR __workStream = 'FACT - Backlog'[Grouping]
VAR __daysOld = 'FACT - Backlog'[Days Old]
RETURN
CALCULATE (
MAX ( 'RAG MATRIX (TESTING)'[RAG] ),
'RAG MATRIX (TESTING)'[Workstream] = __workStream,
__daysOld >= 'RAG MATRIX (TESTING)'[Min Range],
__daysOld <= 'RAG MATRIX (TESTING)'[Max Range]
) + 0
Or like this:
NEW RAG =
VAR __workStream = 'FACT - Backlog'[Grouping]
VAR __daysOld = 'FACT - Backlog'[Days Old]
VAR __result =
CALCULATE (
MAX ( 'RAG MATRIX (TESTING)'[RAG] ),
'RAG MATRIX (TESTING)'[Workstream] = __workStream,
__daysOld >= 'RAG MATRIX (TESTING)'[Min Range],
__daysOld <= 'RAG MATRIX (TESTING)'[Max Range]
)
RETURN
IF ( __result = BLANK (), 0, __result )
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.