See how to easily convert aggregated values (i.e. Total Sales) from one currency to a multitude of currencies with a few measures.

Please watch videos on currencies below:
How To Format Currencies in Power BI w/DAX - [ Ссылка ]
Accounting For Missing Currency Rates w/DAX - [ Ссылка ]
Accounting For Missing Data In Currency Table w/PowerQuery - [ Ссылка ]

***** Video Details *****
2:25 data model
4:15 create basic measures
4:47 add slicer from dimension currency rates
6:56 converted sales measure
8:43 take a column from the dimension currency table and put on Column

***** Learning Power BI? *****
FREE COURSE - Ultimate Beginners Guide To Power BI - [ Ссылка ]
FREE COURSE - Ultimate Beginners Guide To DAX - [ Ссылка ]
FREE - Power BI Resources - [ Ссылка ]
FREE - 60 Page DAX Reference Guide Download - [ Ссылка ]
Enterprise DNA Membership - [ Ссылка ]
Enterprise DNA Online - [ Ссылка ]
Enterprise DNA Events - [ Ссылка ]

***** Related Links *****
Multiple Currency Logic In Power BI – A LOOKUPVALUE Example - [ Ссылка ]
Power BI Exchange Rates: An Update To Multiple Currencies Management - [ Ссылка ]
Implementing DAX Measure Groups Into Your Reports – A Power BI Modeling Review - [ Ссылка ]

***** Related Course Modules *****
Business Analytics Series - [ Ссылка ]
Best Practices & Feature Reviews - [ Ссылка ]
Ultimate Beginners Guide to DAX - [ Ссылка ]

***** Related Support Forum Posts *****
Formatting Issues With Currency In Power BI - [ Ссылка ]
Calculate Currency Exchange Impact Between 2 Years - [ Ссылка ]
Converting To Foreign Currencies - [ Ссылка ]
For more currency queries to review see here…. - [ Ссылка ]

свернуть