Skip to main content
Microsoft Idea

Power BI

New

Create a DAX measure or a technique to bring in the Excel Data Selector Data Types in Power BI

Vote (1) Share
Chintan Patel's profile image

Chintan Patel on 04 Jun 2023 15:06:18

In Excel, one can easily populate certain data using the "Stock", "Currency" and "Geography" data types. Reference:


https://support.microsoft.com/en-us/office/use-the-data-selector-to-specify-data-types-89c22826-5594-455c-b448-b2cd0e1869f3


Can this be brought to Power BI? It would be particularly helpful if a LIVE exchange rate via the "Currency" data type can be brought into Power BI so calculations with LIVE currency exchange rates can be done, and be displayed in visuals like cards, KPIs and visuals that use line charts.