cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Nilanka Frequent Visitor
Frequent Visitor

Need help with column calculation

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.


 Power BI capture.JPG
3 ACCEPTED SOLUTIONS

Accepted Solutions
Nilanka Frequent Visitor
Frequent Visitor

Re: Need help with column calculation

I am still not able to calculate it this is the error i get

 

Capture power bo.JPG

themistoklis New Contributor
New Contributor

Re: Need help with column calculation

Change the last VoucherLog[Currency] to VoucherLog[Package Price]

Community Support Team
Community Support Team

Re: Need help with column calculation

HI, @Nilanka

There is a mistabke in your formula

Column = IF(VoucherLog[Currency]="Eur",9.54*VoucherLog[Package Price],IF(VoucherLog[Currency]="DKK",1.28*VoucherLog[Package Price],IF(VoucherLog[Currency]="NOK",VoucherLog[Currency])))
 
Column = IF(VoucherLog[Currency]="Eur",9.54*VoucherLog[Package Price],IF(VoucherLog[Currency]="DKK",1.28*VoucherLog[Package Price],IF(VoucherLog[Currency]="NOK",VoucherLog[Package Price])))
 
Note: Black body part

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
10 REPLIES 10
Omega Established Member
Established Member

Re: Need help with column calculation

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)

 

themistoklis New Contributor
New Contributor

Re: Need help with column calculation

You can also use an if statement:

 

Measure = IF([Currency] = "EUR", 9.54 * [Package_Price], IF([Currency] = "DKK", 1.28 * [Package_Price], [Package_Price]))
affan Established Member
Established Member

Re: Need help with column calculation

Hi @Nilanka

 

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)

exchgRate.gifExchange Rate

 

 

 

 

If this helped you, please mark this post as an accepted solution and like to give KUDOS .

 

Regards,

Affan

Nilanka Frequent Visitor
Frequent Visitor

Re: Need help with column calculation

"Operator or expression '( )' is not supported in this context."

 

i got this as a reply , what is my mistake here

affan Established Member
Established Member

Re: Need help with column calculation

Which solution have you tried from the above ones?
Community Support Team
Community Support Team

Re: Need help with column calculation

HI, @Nilanka

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] )
    )
)

16

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Nilanka Frequent Visitor
Frequent Visitor

Re: Need help with column calculation

Currently trying all , but struggling to get the outcome I want. Will be trying it again , i must have made a mistake somewhere

Nilanka Frequent Visitor
Frequent Visitor

Re: Need help with column calculation

I am still not able to calculate it this is the error i get

 

Capture power bo.JPG

themistoklis New Contributor
New Contributor

Re: Need help with column calculation

Change the last VoucherLog[Currency] to VoucherLog[Package Price]