Calculated Column

[Anonymous]

Hi All, 

I have a daatset with a transactions table, I want to create a caculated column that checks for a type of transaction using the TansactionType ID Column and execute a calculation on Amount Column and the reports a value into the new calculated column.

For example:

If TransactionType is 1, Return amount in Amount Column multiplied by 2

If TransactionType is 2, Return amount in Amount Column.

If TransactionType is 15, Return amount in amount table minus 500.

So bascially, I want a Calculated Column thats checks for a transactionID, and returns a calulation on the Amount Column

Any help would be appreciated.

[amitchandak · Accepted solution]

@Anonymous , Create a new column like

Switch( True(),
[TransactionType] = 1, [Amount]* 2
[TransactionType]= 2, [Amount]
[TransactionType] =15, [Amount] - 500
)

[parry2k · Accepted solution]

@Anonymous add a new column with the following expression

New Amount = 
SWITCH ( Table[Transactionid],
1, Table[Amount] * 2
2, Table[Amount],
15, Table[Amount] - 500
)

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[amitchandak · Accepted solution]

@Anonymous , Create a new column like

Switch( True(),
[TransactionType] = 1, [Amount]* 2
[TransactionType]= 2, [Amount]
[TransactionType] =15, [Amount] - 500
)