Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
cupedersen
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:
2019-08-20_08-02-41.jpg
 
Anyone that can help me? 
1 ACCEPTED SOLUTION
SteveCampbell
Memorable Member
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]

Annotation 2019-08-20 193011.png

 

 

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

Stay up to date on  linkedin-logo.png
Read my blogs on  powerbi.tips_.png

Remember to spread knowledge in the community when you can! tu.png



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  



View solution in original post

1 REPLY 1
SteveCampbell
Memorable Member
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]

Annotation 2019-08-20 193011.png

 

 

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

Stay up to date on  linkedin-logo.png
Read my blogs on  powerbi.tips_.png

Remember to spread knowledge in the community when you can! tu.png



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  



Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.