Creating New column using condition

Question

Hi,I have a table which has 2 columns:&nbsp;(i) Amount(ii) Fx rate&nbsp;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 that happens, I want to retain the value mentioned in 'Amount' column in the 'New Amount' column. Please find an example below:AmountFx rateNew Amount1001.283.32001.3153.8150null150.0&nbsp;Also, I want to do this operation in my original table and not use a measure.&nbsp;Request for any help! Thanks!

philiptreacy · Accepted Answer

Hi&nbsp;SJHALANI&nbsp;
&nbsp;
Do you want the column created in PQ or in DAX?
&nbsp;
Power Query
= if [Fx rate] is null then [Amount] else [Amount]/[Fx rate]
&nbsp;
&nbsp;
DAX
Column = IF([Fx rate] &gt; 0, DIVIDE([Amount],[Fx rate]), [Amount])
&nbsp;
&nbsp;
Regards
&nbsp;
Phil

Forum Discussion

Creating New column using condition

2 Replies

Related content

Create measure to return value from column when condition met for two other columns

Create conditional index column

Create columns group

Conditional Column with Multiple Conditions

Create Conditional Column Based Upon Two Other Columns

Amount	Fx rate	New Amount
100	1.2	83.3
200	1.3	153.8
150	null	150.0