The Total column
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.
1 answers ( 0 marked as helpful)
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/