"If" Statement in Calcualted Column

[Anonymous]

Hello! I'm trying to create a calulated column in a PBI desktop report utilizing an "If" Statement in order to return a calulated value. I've tried cearting a custom and calculated column so far and have also tried creating DAX expressions with and without a "SWITCH" statement but I can't seem to get anything to work (an example of such a statement is below). Essentially what I'm trying to accomplish is that if my BINGO_AUTOMATION[CURRENT_POD] column is less than my BINGO_AUTOMATION[TARGET_POD] column I want it to caluclate the difference between the two in order to return a engative value.

Column 1 = SWITCH (if (BINGO_AUTOMATION[CURRENT_POD] < BINGO_AUTOMATION[TARGET_POD]) then (BINGO_AUTOMATION[CURRENT_POD] - BINGO_AUTOMATION[TARGET_POD]) else "0")

Thanks in advance for your help!

[PattemManohar · Accepted solution]

@Anonymous You no need to have SWITCH here... Also your IF syntax is not correct.

Please try this... 

if (BINGO_AUTOMATION[CURRENT_POD] < BINGO_AUTOMATION[TARGET_POD],BINGO_AUTOMATION[CURRENT_POD] - BINGO_AUTOMATION[TARGET_POD]
,0)

[Anonymous]

actually, upon further investigation - the formula doesn't filter out instances where the Current >= Target. it's just calculating the measure for every row as opposed to only those where Current < Target.

[Anonymous]

This worked! Thank you so much!

[hthota]

Rewrite the Column as given below.

Column 1 = SWITCH (if (BINGO_AUTOMATION[CURRENT_POD] < BINGO_AUTOMATION[TARGET_POD),(BINGO_AUTOMATION[CURRENT_POD] - BINGO_AUTOMATION[TARGET_POD]),Null)