Forum Discussion
Helper Ifilling 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 actual value present in column 3
Blue colour are column 1 value
Orange colour are column 2 value filled in the desired output table.
Please suggest how to make this desired table.
Thank you in advance
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,
2 Replies
- Greg_Deckler
Community Champion
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])
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,
