Forum Discussion

Anonymous

Not applicable

5 years ago

IF THEN

Is there a way to replicate this formula in Power BI? IF [Org Code] = 'HK' THEN ABS([Item Cost]*[Quantity]) END

Super User

5 years ago

Anonymous , In dax

IF ([Org Code] = "K " , ABS([Item Cost]*[Quantity]) ,blank())

IF ([Org Code] = "K " , ABS([Item Cost])*abs([Quantity]) ,blank())

Anonymous

Not applicable

5 years ago

How to do this if the columns are from different tables?