Forum Discussion
Solved
Creating New column using condition
Hi, I have a table which has 2 columns: (i) Amount (ii) Fx rate I want to create a new column 'New Amount' which is (Amount/Fx rate). However, the Fx rate column can be 'null' at times. When ...
Hi SJHALANI
Do you want the column created in PQ or in DAX?
Power Query
= if [Fx rate] is null then [Amount] else [Amount]/[Fx rate]DAX
Column = IF([Fx rate] > 0, DIVIDE([Amount],[Fx rate]), [Amount])Regards
Phil
Hi SJHALANI
Do you want the column created in PQ or in DAX?
Power Query
= if [Fx rate] is null then [Amount] else [Amount]/[Fx rate]
DAX
Column = IF([Fx rate] > 0, DIVIDE([Amount],[Fx rate]), [Amount])
Regards
Phil
Thank you PhilipTreacy, this works.
I wanted it in Power Query,