Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
@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,
@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,
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])
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |