Forum Discussion

nerdyplayer's avatar
nerdyplayer
Icon for Helper I rankHelper 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
Icon for Community Champion rankCommunity 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