Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi guys,
I am just a newbie in Power BI and I have encountered some difficulties.
One of the difficulties are I have to covert HKD to USD with a fixed rate of 7.8 and add the originally HKD values and USD values together in USD as the total amount in a matrix visual. What my supervisor wants is the matrix only show USD values of both transactions done in HKD and USD, and also the total amount of transactions in USD.
Thank you very much for your assistance.
Solved! Go to Solution.
@Anonymous
You can do the conversion with a measure like this.
Amount USD =
SUMX ('Table', 'Table'[Amount] * IF ( 'Table'[Currency] = "HKD", 7.8, 1 ) )
@Anonymous
You can do the conversion with a measure like this.
Amount USD =
SUMX ('Table', 'Table'[Amount] * IF ( 'Table'[Currency] = "HKD", 7.8, 1 ) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
95 | |
94 | |
79 | |
71 | |
64 |
User | Count |
---|---|
120 | |
105 | |
99 | |
81 | |
72 |