Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
I need to convert local currency amounts to EUR by using the exchange rate of the selected end-year and the last available month of that year. I have a formula that works, but it does not use the same ex rate for each month:
first column is a date column from a date table
second is the local currency amount
3rd: result of my Vlookup ex rate conversion dax measure
4th: ex rate test: shows what ex rate the vlookup measure used
the last 2 columns are the result of 2 measures:
the 2 measures show the same, correct month and year in this table, however in the Vlookup dax measure these values are changing:
Any idea how I could fix this formula?
thank you !
User | Count |
---|---|
21 | |
19 | |
12 | |
9 | |
7 |
User | Count |
---|---|
30 | |
27 | |
14 | |
13 | |
10 |