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.
Buenas tardes,
Estoy armando un tablero, donde concentro informarción de 3 paises con diferentes monedas, me gustaria unificar las divisas en una cuarta, como deberia hacerlo?
Tambien quisiera que haya un boton o filtro donde pueda elegir mostrar la informacion en moneda local o con la moneda unificada.
Si me pueden ayudar se los agradeceria mucho!
Hi @Anonymous,
Can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Are these monthly exchange rates? Where do you get them from?
The standard approach is to have a composite key "CurrencyYearMonth" on both your FX table and your fact table and then do the conversion based on that link.
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 |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |