The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
---|---|
17 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
12 | |
9 | |
8 |