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 |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |