I have two columns Package price and Currency. In the Currency column i have 3 difference currencies present NOK , DKK and EUR.
I want the DKK values from Package price to multiplied by 1.28 and EUR to be multipled by 9.54 and NOK remain same.
So I want to create one column with total NOK price.
Bit confused how to do this.
Solved! Go to Solution.
There is a mistabke in your formula
You can create the similar measure/Column using the below DAX:
Package Price New = Switch (True(), Currency = "DKK", Package Price*1.28, "EUR", Package price*9,54, Package Price)
You can also acheive this by using Power Query.
= Table.AddColumn(#"Changed Type", "ExchangeRate", each if [Currency] = "NOK" then 1 else if [Currency] = "DKK" then 1.28 else if [Currency] = "EUR" then 9.45 else null, type number)
If this helped you, please mark this post as an accepted solution and like to give KUDOS .
Try this formula to add a calculate column
New Package Price = IF ( [Currency] = "EUR", 9.54 * [Package Price], IF ( [Currency] = "DKK", 1.28 * [Package Price], IF ( [Currency] = "NOK", [Package Price] ) ) )