Hello. I have two tables: VKM1, and Currency. I'm trying to create calculated column in VKM to multiply Sale ( from VKM1 table ) with Rate ( from Currency table ). The relationships between tables are active ( many to one ), but for some reason "RELATED" function refuses to work. How to bypass this issue, what other function can be used?

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,

Calculated column with Excchange rate calculation.

5 Replies

Greg_Deckler
Community Champion
6 years ago
Anonymous - Try RELATEDTABLE instead.

Otherwise, not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
- Anonymous
  Not applicable
  6 years ago
  Greg_Deckler
  
  Thank you for reply.
  
  In details,
  
  Two tables. First one "Currency", like below.
  
  Currency Rate
  USD 1,1854
  JPY 125,37
  BGN 1,9558
  CZK 26,097
  DKK 7,4508
  GBP 0,90265
  HUF 344,5
  PLN 4,3935
  RON 4,8345
  SEK 10,2865
  CHF 1,077
  ISK 160,2
  NOK 10,6585
  
  Second one ( VKM1 ) consists of multiple rows, and columns.
  
  Between tables there is relationship may to one ( it is active ).
  
  I have tried RELATEDTABLE:
  
  conversion = SUMX(RELATEDTABLE('Currency'),VKM1[Sale]*'Currency'[Rate])
  
  I have tried RELATED ( even basic version inside table VKM1to check it )
  
  test = RELATED('Currency'[Rate])
  
  Both cases as a result I got blank column ( no errrors, no data )
  
  Please advise.
  - ibarrau
    Super User
    6 years ago
    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,