Forum Discussion

vibhoryadav23's avatar
vibhoryadav23
Icon for Helper II rankHelper II
4 years ago
Solved

Assign a value to missing matches between two tables

Hi,   I am pulling values from Table_2 in Table_1 with a realtionship. But there are some missing values in Table_2 which shows blank values in my Table_1. Instead of blank, I want to hard code a n...
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    You can substitute something else for blanks like this:

    Count =
VAR _Count = SUM ( Table_2[count] )
RETURN
    IF ( ISBLANK ( _Count ), 8, _Count )

     

vibhoryadav23's avatar
vibhoryadav23
Icon for Helper II rankHelper II
4 years ago

Ignore this for now as I have found a workaround for it (By creating a new table with unique values).

 

Thanks for your help!