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.



HotChilli's avatar
HotChilli
Community Champion
2 years ago

networkdays returns an integer, the other path returns a text string.  You can't have those options in a SWITCH/IF. You have to return the same type from all paths