visual card
1 Topic
If date value is not blank return date value if date value is blank return "Text"
Hello I need a measure for a card visual to display a date value if present however if it's blank display a custom text such as "NONE" The date field(expectedresultdate) is a data type of "Date". The custom text if the field is blank is just "Text". Heres what I have. next update = IF(ISBLANK(SELECTEDVALUE('Annual Metrics'[ExpectedResultDate])),SELECTEDVALUE('Annual Metrics'[ExpectedResultDate],"NONE"),SELECTEDVALUE('Annual Metrics'[ExpectedResultDate])) Thank you,Solved1.4KViews0likes5Comments