The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
---|---|
11 | |
9 | |
6 | |
6 | |
5 |
User | Count |
---|---|
22 | |
14 | |
14 | |
9 | |
7 |