Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Calculated Column

Hi All,    I have a dataset with a Transactions Table, I want to create a caculated column that checks for a TransactionType using the TansactionType ID Column and then returns a value based off a ...
DAX Calculation
Dax commands help
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

I tried this syntax:

 

Revenue =
VAR TransactionID = Transactions[TransactionTypeId]
VAR TransactionAmount = Transactions[Amount($)]
VAR ReturnAmount =
SWITCH(
TRUE(),
TransactionID = 1, TransactionAmount,
TransactionID = 2, 6 * 360.5,
TransactionID = 72, TransactionAmount,
TransactionID = 4, 0,
TransactionID = 5, TransactionAmount,
TransactionID = 12, 0,
TransactionID = 49, TransactionAmount * 0.65,
TransactionID = 66, TransactionAmount,
TransactionID = 68, TransactionAmount,
TransactionID = 69, TransactionAmount,
TransactionID = 67, TransactionAmount,
TransactionID = 35, TransactionAmount - 500,
0
)
RETURN
Result
 
 
But still returns an error message. Please what do i define inside of the RETURN function
Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI Anonymous ,

 

You code is okay.

You need to return Return Amount

 

Better Formatted Code

 

Revenue =
VAR TransactionID = Transactions[TransactionTypeId]
VAR TransactionAmount = Transactions[Amount($)]
VAR ReturnAmount =
    SWITCH (
        TRUE (),
        TransactionID = 1
            || TransactionID = 5
            || TransactionID = 72
            || TransactionID = 66
            || TransactionID = 68
            || TransactionID = 69
            || TransactionID = 67, TransactionAmount,
        TransactionID = 2, 6 * 360.5,
        TransactionID = 49, TransactionAmount * 0.65,
        TransactionID = 35, TransactionAmount - 500,
        0
    )
RETURN
    ReturnAmount

 

 

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)