Hello
I have an issue with the currency exchange rate. I have attached my pbix as a sample file. I was able to fetch the rate for USD and EURO without any year. Since every year in my company base rate changes. So I want to view the revenue based on GBP, EUR and USD in my file. So if I use the revenue same period last year it will provide me with the revenue based on conversion rate last year and similar this year will provide me based on this year.
Please if you can help me to solve this.https://drive.google.com/file/d/1JqV-Xt_dCzFnRk1s4ec_nUryTzdfD3oP/view?usp=sharing
I have an issue with the currency exchange rate. I have attached my pbix as a sample file. I was able to fetch the rate for USD and EURO without any year. Since every year in my company base rate changes. So I want to view the revenue based on GBP, EUR and USD in my file. So if I use the revenue same period last year it will provide me with the revenue based on conversion rate last year and similar this year will provide me based on this year.
Please if you can help me to solve this.https://drive.google.com/file/d/1JqV-Xt_dCzFnRk1s4ec_nUryTzdfD3oP/view?usp=sharing