Forum Discussion
Relationship error in DAX
Dear All,
I am writing bcause I have a problem when I try to convert a price to another currency. The exchange rate depends on the date. I have three tables:
(1) one with the date of the exchange rate and the exchange rate
(2) one with the date of the bill, the id of the bill and the currency of the value
(3) one with the id of the bill and the value of the bill (price)
The tables (1) and (2) are connected via the date (1-n relationship) and the tables (2) and (3) are connected via the id (1-n relationship) (see picture).
I am able to show the rate and the price in a table, but I am not able to multipy those two value in a calculated column. The DAX is the following:
But then I get this error: "The column either doesn't exist or doesn't have a relationship"
Does anybody know how I can solve this problem?
Thank you in advance and kind regards,
Matze
1 Reply
- v-lili6-msftCommunity Support
HI, matze
I have test on my side, it works well, could you share you sample pbix file for us have a test?
Best Regards,
Lin