Forum Discussion

dineshkumar_vrv's avatar
dineshkumar_vrv
Icon for Helper I rankHelper I
9 years ago
Solved

filling blanks with previous column text

I want to fill the blanks of column3 with words of column2 if both columns are blanks than fill the column with column 1 else blank   please refer the screen shot     Black colour are actu...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    dineshkumar_vrv,

    You can also use the following DAX to calculate Column 4.

    Column 4 = IF(Table[Column3]=BLANK(),IF(Table[Column2]=BLANK(),Table[Column1], Table[Column2]),Table[Column3])



    Regards,

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

I believe that you will need a column 4 with the formula:

 

Column 4 = IF(ISBLANK([Column 3]),IF(ISBLANK([Column 2]),[Column 1], [Column 2]),[Column 3])