Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, I searched for a combination of my topics but was not able to find the solution for my problem.
I have an online connection which I only update frequently where I get several values (e.g. Net sales, different Cost categories) and calculate values on top (e.g. Gross Margin, price and cost per unit).
The values so far only in one base currency.
Beside the visuals in the Dashboards also the information can be downloaded for "Analyse in Excel".
So far I created a currency table with rates including the base currency with a measure called "Selected currency":
I tested a switch formula which worked very well in the visuals:
Solved! Go to Solution.
Hi @Hi69
You can try the following solution.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you very much for your reply.
Unfortunately it is not working - both are working in the Dashboards (depending on relationship or not) but non of them are finally working in the "Analyse in Excel" file.
Hi @Hi69
You can try the following solution.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yes, yes, yes 😄 - that is working.
Thank you so much!
@Hi69 , you have to use max/min or related if the is 1-m realtion
Net Sales currency = SWITCH(TRUE(),
[Selected currency]="EUR", [Net Sales SEK]*Max('Currency'[Rate]),
[Selected currency]="USD", [Net Sales SEK]*Max('Currency'[Rate]),
[Selected currency]="SEK", [Net Sales SEK]*Max('Currency'[Rate]))
Net Sales currency = SWITCH(TRUE(),
[Selected currency]="EUR", Sumx( Table, [Net Sales SEK]*realted('Currency'[Rate])),
[Selected currency]="USD", Sumx( Table, [Net Sales SEK]*realted('Currency'[Rate])),
[Selected currency]="SEK", Sumx( Table, [Net Sales SEK]*realted('Currency'[Rate])))
refer few more options
currency
https://www.youtube.com/watch?v=4dosxfNxR6M
https://www.sqlbi.com/articles/currency-conversion-in-power-bi-reports/
https://radacad.com/currency-converter-power-bi-function-part-1
https://www.youtube.com/watch?v=Q4hF4CwJsFEhttps://radacad.com/currency-exchange-rate-conversion-in-...
https://businessintelligist.com/2015/03/17/power-bi-tutorial-how-to-implement-currency-conversion-us...
https://blog.beyondimpactllc.com/blog/building-a-dynamic-currency-converter-with-power-bi
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |