Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Incorrect document currency and totals

Hi, 

 

I need help with some incorrect totals and currencies. The data in input system has amounts in different currencies:

 

For example: 

But when we upload the data to Power BI, then for Amount in Doc Cur it can only recognize one currency (CNY) and HKD is missing: 

In Power BI, I can only choose to display first or last currency. Is there another way to get the totals as they are in the input system? 

 

Thank you in advance.  

Need Help

4 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi Anonymous,

     

    Can you share the file?

    1. Where is the data from input system stored? Seems your image here didn't show the original data. In other words, what's the data source of that report? SQL DB or Excel workbook, etc.

    2. How does it look like in the Query Editor?

     

    Best Regards,

    Dale

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi v-jiascu-msft, 

       

      Thanks for the reply. 

       

      Unfortunately, I cannot share the file, but the data is stored in a Data Warehouse and we import it by using Oracle database. 

       

      Since it's imported from the database, it doesn't show up in Query editor. 

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        8 years ago

        Hi Anonymous,

         

        It will show up in the Query Editor as a query. Please post a snapshot of that. You can mask the sensitive data first. We need to check out the data structure.

        Incorrect_document_currency_and_totals

         

        Best Regards,

        Dale