Calculate on same field with a currencyFactor

cupedersen — Tue, 20 Aug 2019 06:16:42 GMT

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?

Re: Calculate on same field with a currencyFactor

SteveCampbell — Wed, 21 Aug 2019 00:30:54 GMT

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!

topic Re: Calculate on same field with a currencyFactor in DAX Commands and Tips

Calculate on same field with a currencyFactor

Re: Calculate on same field with a currencyFactor