Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply

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

 

Spl.PNG

 

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

 

1 ACCEPTED SOLUTION
v-yuezhe-msft
Employee
Employee

@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])

1.PNG

Regards,

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yuezhe-msft
Employee
Employee

@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])

1.PNG

Regards,

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Greg_Deckler
Super User
Super User

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])

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.