Forum Discussion
StefanoGrimaldi
Resident Rockstar
Resident RockstarMerge value with blank results and adjust it
hey guys, have a little topic to see if possible, Im doing a merge in power query by date from one table to another to get a exchange ratio for a group of invoice, but the exchange ratio ha...
Seems like if you sort it ascending then you can just use Table.FillDown.
--Nate
- StefanoGrimaldi
this a good idea I even try it but the problem its that maybe the invoice doesnt goes according in dates and the the ratio could have change in the blanks between the invoice vs the rates register. like I oculd have a ratio one month and another no but have a invoice each 2 or 3 month so the ratio that takes its the one 3 month before instead of the month before for the actual date of the invoice. so it would be kind of filling down on the ratio table, but cant find how to add the missing dates for them use a fill down on the ratio table query.
