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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
maurcoll
Helper III
Helper III

missing data in column

Good Afternoon

I have a table which contains data like the below. Some of the completed by fields are blank and i need to fill them in. If the order number is the same then it will be completed by the same person.

 

DateOrder NumberReview TypeCompleted by
31/01/2023123First2589
31/01/2023123Second 
31/01/2023234First1116
31/01/2023234Second1116

 

In the above example i need a way of copying the completed by into the row below.

1 ACCEPTED SOLUTION
Dangar332
Super User
Super User

Hi, @maurcoll 

add new column  using below dax
just adjust your table and column name

 

Column = 
var a = 'Table (5)'[Order Number]
var b = var a = 'Table (5)'[Order Number]
var b = 'Table (5)'[Date]
var c = MAXX(FILTER('Table (5)','Table (5)'[Order Number]=a && 'Table (5)'[Date]=b),'Table (5)'[Completed by])
return
IF('Table (5)'[Completed by]=BLANK(),c,'Table (5)'[Completed by])

 

 

Dangar332_0-1699454107555.png

 

 

View solution in original post

4 REPLIES 4
Ahmedx
Super User
Super User

and  try this

Table.Group(#"Changed Type", {"Order Number"}, {{"Count", each Table.FillDown(_,{"Completed by"})}})

watch my video and find out how to do this in power query

 https://1drv.ms/v/s!AiUZ0Ws7G26Ri19fffg7mGODqcjB?e=NdJxHh

maurcoll
Helper III
Helper III

That has worked thank you

Ahmedx
Super User
Super User

pls try this

Screenshot_2.png

Dangar332
Super User
Super User

Hi, @maurcoll 

add new column  using below dax
just adjust your table and column name

 

Column = 
var a = 'Table (5)'[Order Number]
var b = var a = 'Table (5)'[Order Number]
var b = 'Table (5)'[Date]
var c = MAXX(FILTER('Table (5)','Table (5)'[Order Number]=a && 'Table (5)'[Date]=b),'Table (5)'[Completed by])
return
IF('Table (5)'[Completed by]=BLANK(),c,'Table (5)'[Completed by])

 

 

Dangar332_0-1699454107555.png

 

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.