Personalized Community is here!
Quickly customize your community to find the content you seek.
MCC badges awarded For April - June
Check out the latest community members who earned a Microsoft Dynamics 365 Community Contributors (MCC) badge. | View
2022 Release Wave 1 PlanDynamics 365 release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.
2022 release wave 1 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
If you're selling globally, integrating multiple currency rates into your transactional data is a common scenario within your financial analysis. I get a lot of questions in the Enterprise DNA Support Forum from accountants and finance people who want to work out their sales that are valued in their home currency.
Sales data is always recorded regardless of the currency and the currency code or name. It could be USD, AUD, CAD, EUR, etc. You need to integrate a lot of historical exchange rates, as these change through time. And so, the exchange rate equivalent is going to be very different, depending on the sale day.
I’m going to share my video tutorials on how you can solve this inside Power BI. It’s a bit complexed and advanced, and it’s important that you understand the DAX formula as well as the data model.
The first tutorial will show you how you can integrate the currency table into your data model, how the model is set up, and how to work out a formula to calculate sales with the adjusted currency values.
Key Take Away
Having to integrate currency data or exchange rates into a financial analysis is very common in any business dealing with sales from different regions of the world. In this post, I share with you a unique approach in solving this inside Power BI.
If you could learn and understand the DAX combination and data modeling techniques I use in the tutorials well, calculating your sales and revenue correctly would be fast and easy.
I hope you can implement this into your own financial analysis easily.
All the best!
***** Related Links *****
Creating A Currency Conversion Table In Power BI
Format Currencies In Power BI Using DAX
How To Deal With Products That Have Changing Prices Overtime In Power BI
***** Related Course Modules*****
Advanced Analytics in Power BI
Business Analytics Series
Mastering DAX Calculations
***** Related Support Forum Posts *****
Multi-currencies With Correct Currency Label
Calculate Currency Exchange Impact Between 2 Years
For more exchange rates support queries to review see here….
Business Applications communities