Calculation of Power BI into Quick sight

Question & Answer
, ,
1

Following is the measures used in POWER BI.
" if ( Currency_Code == “EUR”) {Sales_PriceOrdered_Quantity } else if (Currency_Code == “USD”) {Sales_Price/ 1.14Ordered_Quantity} "

What will be the calculation which can be used into Quicksight.?

2

Hi @Hemant_rangdal ,

should be something like.

ifelse( Currency_Code = "EUR", {Sales_Price}*{Ordered_Quantity}, Currency_Code = "USD", {Sales_Price}/1.14*{Ordered_Quantity},0)

or if its only EUR and USD

ifelse( Currency_Code = "EUR", {Sales_Price}*{Ordered_Quantity}, {Sales_Price}/1.14*{Ordered_Quantity})

1 Like
3

thank you @ErikG
it works

2 Likes
4

Thanks for letting us know @ErikG’s solution worked for you and for marking it as solved – which helps the Community! :slight_smile:

Thanks @ErikG, as always, for sharing your expertise!