Forum Discussion
Solved
Card visual two options
Hi Experts
Is it possible to have two option in the following DAX
if the Cell is blank then then below, else if the Cell Has TBC then TBC. Is this possible.
5.2 Blanks =
VAR Avalue = AVERAGE([5.2])
RETURN
IF(ISBLANK(Avalue),"N/A",Avalue)
Not sure what your question is.
You can also use COALESCE
5.2 Blanks = COALESCE(AVERAGE([5.2]),"N/A")
1 Reply
Not sure what your question is.
You can also use COALESCE
5.2 Blanks = COALESCE(AVERAGE([5.2]),"N/A")