Forum Discussion
DATEDIFF with blanks and nulls
Hello, I have to calculate the difference in number of days between two columns. The problem I am having with Date Diff is that the second column includes 'N/A's and blanks. Here's the details. ...
lbendlin
Super User
Super UserYou're on the right track. First you need to define clear business rules for each scenario (N/A and <blank> are separate scenarios!) and then you modify your DAX accordingly. Use SWITCH() and COALESCE() - they are your friend.