Forum Discussion

hamadani's avatar
hamadani
Frequent Visitor
4 years ago
Solved

Replace (Blank) when Merging Two Tables

Hi,   I have two tables as follows:   Table 1 Case Id           Case Name 1 A 2 B 3 C 4 D 5 E 6 F 7 G Table 2 Case Id                  Stage 1 Stag...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi,
    I would recommend doing a full outer join and using this in power query to fill the blanks with what you desire.

    Column = IF(ISBLANK([Column]),0,[Column)

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
4 years ago

hamadani You will need a disconnected table (no relationships) containing Stage I, Stage II, Stage III and Registered Only as rows. You would then construct a measure to calculate accordingly.

 

  • hamadani's avatar
    hamadani
    Frequent Visitor
    4 years ago

    Thanks Greg_Deckler . Do you mean, I need to create a third table with Stage names only? Please note the "Registered Only" is not one of the current stage names in Table 2 and the blanks (which I want to replace its name to Registered Only in my visualisation), only appear after creating a relationship between Table 1 and 2 (which I require that relationship for other purposes too)