Forum Discussion

Oana's avatar
Oana
Advocate I
4 years ago
Solved

Index Match through Power Query or DAX

I hope there is someone who ran into this and has found a solution.    I am importing a table in PowerBI where I have several columns with: Name,  Invoice Number, Code, Invoice Date, Invoice Due Da...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Oana , try

    new column =
    var _max = maxx(filter(Table, [Invoice Number] = earlier([Invoice Number]) ), [Invoice Due Date])
    return
    if( isblank([Invoice Due Date]), _max, [Invoice Due Date])

amitchandak's avatar
amitchandak
Super User
4 years ago

Oana , try

new column =
var _max = maxx(filter(Table, [Invoice Number] = earlier([Invoice Number]) ), [Invoice Due Date])
return
if( isblank([Invoice Due Date]), _max, [Invoice Due Date])

Oana's avatar
Oana
Advocate I
4 years ago

This was great, it worked perfectly, it filled in all blank Invoice Due Date with a date! Keep on the great work amitchandak !!!