cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Regular Visitor

## Calculate on same field with a currencyFactor

Hi All

I have an issue where i in the same collum have differnt types of amounts and in different currency. But i need to calculate it to DKK for them all. i have an factor for other than DKK, thats set to 0.

I made this command - that works in Qlickview - but need something that works in PowerBi

IndkøbsprisDKK = if (Currency_Factor = 0 ; (Amount))
IndkøbsprisDKK = if (Currency_Factor < 0 ; (Amount / Currency_Factor))
IndkøbsprisDKK = if (Currency_Factor > 0 ; (Amount / Currency_Factor))

this is my dato and how it looks:

Anyone that can help me?
1 ACCEPTED SOLUTION
Memorable Member

You can go to Add Column, then Custom Column and type the following:

`if [Currency_Factor] = 0 then [Amount] else  [Amount] / [Currency_Factor]`

Love hearing about Power BI tips, jobs and news?
I love to share about these - connect with me!

Remember to spread knowledge in the community when you can!

Did I answer your question? Mark my post as a solution! Proud to be a Super User!

Connect with me!
Stay up to date on
Read my blogs on

Memorable Member

You can go to Add Column, then Custom Column and type the following:

`if [Currency_Factor] = 0 then [Amount] else  [Amount] / [Currency_Factor]`

Love hearing about Power BI tips, jobs and news?
I love to share about these - connect with me!

Remember to spread knowledge in the community when you can!

Did I answer your question? Mark my post as a solution! Proud to be a Super User!

Connect with me!
Stay up to date on
Read my blogs on

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors