Forum Discussion

nerdyplayer's avatar
nerdyplayer
Helper I
2 years ago
Solved

need help with a switch function with a null value

Always having problems with blank value.  i am trying to do a switch function, if the date value is blank "--"  if not, formula will do a datediff between 2 dates.   testing = switch( TRUE, ...
DAX
isblank
Null
switch
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi nerdyplayer 
    the main issue is confliction of data type within the same column.
    Hence to avoid this confliction I have converted the final value in string.
    Please check the below snap

    If this resolves your issue then please accept the same as your solution.



nerdyplayer's avatar
nerdyplayer
Helper I
2 years ago

thank you all. it was indeed the conflicted between the dash. I did need for the dashes for another column and it was useful for me. thank you all again.