I have workbook with power query queries. I'm trying to get currency rates into yellow column, based on parameters specified in green column (currency symbol) and blue column (date).
Query refer to internet csv, updated every workday, so I would prefer to not downloading full data table into workbook, but only looked rates for specified days.
Any idea how to do it with M?
Link to workbook:
Dropbox
Query refer to internet csv, updated every workday, so I would prefer to not downloading full data table into workbook, but only looked rates for specified days.
Any idea how to do it with M?
Link to workbook:
Dropbox