Forum Discussion

maurcoll's avatar
maurcoll
Helper IV
2 years ago
Solved

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 t...
Need Help
  • Dangar332's avatar
    Dangar332
    2 years ago

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