Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello all,
I have a table with several values in different currencies (7 currencies in total).
How do I get the total sum of a HeadCount, considering the currency conversion?
Eg.: I would like to get the sum of all the values from the attached table in dollar.
Any idea?
Solved! Go to Solution.
@Anonymous ,
You may use LOOKUPVALUE Function to add a calculated column in DAX.
http://community.powerbi.com/t5/Desktop/Excurr/m-p/361854#M163415
Hi, for your query, first i've performed "unpivot" transformation to dates column in "Arg_Orçado" table. After, i've created the relationship between "ID_moeda" and "currency" columns. Then i've created "DOLLAR" measure for aplied the exchange rate to the values.
anyway, this is the pbix that i've worked:
Converting other currencies to USD is clear, but how is HeadCount dependent on Currency Conversion?
Or are you looking for the Sum of HeadCount for records that are in USD.
Regards,
Tarun
Really, my doubt is very vague. I will try to explain my situation better now.
I have a spreadsheet with several values budgeted of South America. There are 7 countries in total (Brz, Arg, Chi, Col, Per, Ecu, Uru). The budgeted amounts are in the local currencies of the respective country. That is, 7 different currencies.
My idea is to create 5 tabs:
South America
Brz
Arg, Chi, Uru
Col, Ecu
Per
To get the sum of the total budgeted for HeadCount, I created a measure using CALCULATE and SUMX (after I unpivot the columns):
Total Budget = CALCULATE(SUMX('SA_Budget','SA_Budget'[Value]))
@Anonymous ,
You may use LOOKUPVALUE Function to add a calculated column in DAX.
http://community.powerbi.com/t5/Desktop/Excurr/m-p/361854#M163415
User | Count |
---|---|
93 | |
85 | |
78 | |
67 | |
63 |
User | Count |
---|---|
113 | |
99 | |
97 | |
64 | |
59 |