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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
narasimhuluk
Frequent Visitor

Power Query Editor

Hi Folks 

 

can we copy a cell value and paste in different cell as we do in excel ...copy /Paste 

i have some thing like as 

column 

 

abc  --- cell1

null --- cell2

null ---cell3

bed ---cell4

null ---cell15

null ---cell6

 

i want to replace abe with first two nulls and bed with next two nulls ...

 

I cheched with replace values but it is replaycing all the null values but i want to replace only particular null cells not all of them 

how do we do that in editor 

 

 

 

1 ACCEPTED SOLUTION
Zubair_Muhammad
Community Champion
Community Champion

@narasimhuluk 

 

You can select the column and then use the FillDown function in Query Editor/Power Query

 

fdown.png


Regards
Zubair

Please try my custom visuals

View solution in original post

1 REPLY 1
Zubair_Muhammad
Community Champion
Community Champion

@narasimhuluk 

 

You can select the column and then use the FillDown function in Query Editor/Power Query

 

fdown.png


Regards
Zubair

Please try my custom visuals

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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