Forum Discussion
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...
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])
Due Date Aging CC =
VAR currentinvoicenumber = Data[Invoice Number]
VAR duedate =
MAXX (
FILTER ( Data, Data[Invoice Number] = currentinvoicenumber ),
Data[Invoice Due Date]
)
RETURN
INT ( TODAY () - duedate )
Hi Jihwan, thank you for your DAX solution, it really close to what I was looking for, but it calculated Aging based on TODAY(), which is a different interval. I was looking for the same Invoice Due Date to be copied over in the blanks based on Invoice Number. The solution below worked, I do appreciate it though!