Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a table as per below which shows a value per day in GBP.
Date | Amount in GBP |
01.01.2021 | 10 |
02.01.2021 | 15 |
I also have another table which shows the daily conversions:
Date | GBP to USD |
01.01.2021 | 1.32 |
02.01.2021 | 1.31 |
I want to be able to add a column to the table A with the daily value in USD.
Date | Amount in GBP | Amount in USD |
01.01.2021 | 10 | 13.2 |
02.01.2021 | 15 | 19.65 |
Please advise on the calulation to get this daily based on the changing values per date.
Solved! Go to Solution.
@andrewb95 calculated column as following assuming no relationship
Column = CALCULATE(MAX(Conversion[GBP to USD]),FILTER(Conversion,Conversion[Date]=CALCULATE(MAX(GBP[Date])))) * CALCULATE(MAX(GBP[Amount in GBP]))
same result assuming there is a relationship
Column = RELATED(Conversion[GBP to USD])*GBP[Amount in GBP]
@andrewb95 calculated column as following assuming no relationship
Column = CALCULATE(MAX(Conversion[GBP to USD]),FILTER(Conversion,Conversion[Date]=CALCULATE(MAX(GBP[Date])))) * CALCULATE(MAX(GBP[Amount in GBP]))
same result assuming there is a relationship
Column = RELATED(Conversion[GBP to USD])*GBP[Amount in GBP]