Forum Discussion
Create a FX Table with Existing Data
I'll preface this inquiry by saying I'm a finance guy with some coding experience which makes me a little dangerous. The concept is essy, I can determine historical FX rates using exisitng data...
I strongly recommend to turn the table with monthly FX-rates into a table with daily FX-rates in the query-editor. That way you can retrieve all necessary date-aspects from your date-dimension and don't have to bother about different date-granularities in DAX.
Simply:
1) Reference your date-dimension(table) and remove all columns, but: Date, Month and Year
2) Merge your FX-table on Month and Year with it and expand the necessary columns
3) Remove Month and Year- columns