In case we have an "email" who made two purchases with diff currencies, how the total will appear? And we have this problem in the last cell of the matrix, it gave us the total as a number, which is not well presented since we're calculating the total of prices with diff currency and not numbers. thanks.

To convert all currencies into one is more complicated than drag and drop across visuals. This can be achieved using DAX and Power Query, however we are too early in the course to introduce complex methods. If you are interested in currency conversion, I suggest you watch: https://learn.365datascience.com/courses/preview/power-query-and-data-modeling/ and also https://learn.365datascience.com/courses/preview/introduction-to-dax/

Follow this topic

ELMEHDI GOUDIR

Last answered:

15 Mar 2023

Posted on:

14 Mar 2023

The Total column

in Power BI / Task Three, Part 2

1 answers ( 0 marked as helpful)

Dimitar Shutev

Instructor

Posted on:

15 Mar 2023

The Total column

Submit an answer

related questions