Forum Discussion
Calculated column with Excchange rate calculation.
Hi, if creating a calculated column in VKM1 like this is not working (you only obtain blank values):
test = RELATED('Currency'[Rate])Then check the relationship because it might be not finding matches. Add a table visualization with columns used in the relationship from both tables. Check if they are matching or you have just blank values. This is a usual problem if the columns you use in the relationship don't have the same type or have different texts cases (upper, lower)
Let us know what you find!
Regards,
Super UserHi, if creating a calculated column in VKM1 like this is not working (you only obtain blank values):
test = RELATED('Currency'[Rate])Then check the relationship because it might be not finding matches. Add a table visualization with columns used in the relationship from both tables. Check if they are matching or you have just blank values. This is a usual problem if the columns you use in the relationship don't have the same type or have different texts cases (upper, lower)
Let us know what you find!
Regards,
Thank you for replies, it lead me to the couse.
Oryginal exchange rates file is in csv format, in format pasted below. After transforming in Power Query, it still had space at the beginning of each 3 letter currency code. Removing space solved issue ... .
Date, USD, JPY, BGN, CZK, DKK, GBP, HUF, PLN, RON, SEK, CHF, ISK, NOK, HRK, RUB, TRY, AUD, BRL, CAD, CNY, HKD, IDR, ILS, INR, KRW, MXN, MYR, NZD, PHP, SGD, THB, ZAR, EUR
05 August 2020, 1.1854, 125.37, 1.9558, 26.097, 7.4508, 0.90265, 344.50, 4.3935, 4.8345, 10.2865, 1.0770, 160.20, 10.6585, 7.4683, 86.3692, 8.3311, 1.6415, 6.2311, 1.5703, 8.2277, 9.1871, 17247.57, 4.0397, 88.7090, 1405.74, 26.7125, 4.9698, 1.7809, 58.120, 1.6228, 36.759, 20.4221, 1.00