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,

Anonymous's avatar
Anonymous
Not applicable
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,