Calculate on same field with a currencyFactor

[cupedersen]

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? 

[SteveCampbell · Accepted solution]

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!

Stay up to date on  
Read my blogs on  

Remember to spread knowledge in the community when you can!