Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
Hello all,
I am trying to show sales into USD and Pounds.
basically I have Currency exchange table which have from_currency (Euro as base currency) and To_currency (Other currencies) and value.
I have used this formula below and is throwing error,
Kindly help me out !
Solved! Go to Solution.
Hi @analytics-ecoma ,
Please try:
New Sales conversion =
IF(SELECTEDVALUE(curency_exchange[to_currency_code]) = "USD", FORMAT([Total Sales]* SELECTEDVALUE(curency_exchange[value]), "$0,00",
IF(SELECTEDVALUE(curency_exchange[to_currency_code]) = "GBP", FORMAT([Total Sales]* SELECTEDVALUE(curency_exchange[value]), "$£0,00"))
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @analytics-ecoma ,
Please try:
New Sales conversion =
IF(SELECTEDVALUE(curency_exchange[to_currency_code]) = "USD", FORMAT([Total Sales]* SELECTEDVALUE(curency_exchange[value]), "$0,00",
IF(SELECTEDVALUE(curency_exchange[to_currency_code]) = "GBP", FORMAT([Total Sales]* SELECTEDVALUE(curency_exchange[value]), "$£0,00"))
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This is awesome, thanks Li 🙂
Hello,
It is throwing an error. Is there any way to specifically pick the value of selected currency ?
@analytics-ecoma , try like
New Sales conversion =
Switch(true(),
SELECTEDVALUE(curency_exchange[to_currency_code]) = "USD", FORMAT([Total Sales]* VALUES(curency_exchange[value]), "$0,00"),
SELECTEDVALUE(curency_exchange[to_currency_code]) = "GBP", FORMAT([Total Sales]* VALUES(curency_exchange[value]), "$£0,00") )