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.
My database has information in two different currencies and I want to create a parameter in the dashboard for showing the data in a specific currency.
I want to make the conversion from one currency to another with a SQL query.
Example:
The data is on CLP and USD currencies.
If I choose CLP, all the data that is on USD will be converted to CLP and showed in CLP.
If I choose USD, all the data that is on CLP will be converted to USD and showed in USD.
Third option to show data on its original currency.
How can it be done?
Solved! Go to Solution.
Hi @Anonymous
You may have a look at below post to check if it could help you.If you need further help,please share some sample data and expected output which would be helpful to provide an accurate solution.You can also upload the .pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.
Regards,
Hi @Anonymous
You may have a look at below post to check if it could help you.If you need further help,please share some sample data and expected output which would be helpful to provide an accurate solution.You can also upload the .pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.
Regards,
Hi @Anonymous
Could you tell me if your problem has been solved? If it is,kindly mark the helpful answer as a solution and welcome to share your own solution. More people will benefit from here. If not, please share more details for us so that we could help further on it.
Regards,
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 |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |